What is Synonym in Netezza:
-          The name of a synonym is subject to the same restrictions as the name of a table or view. The synonym name must be unique within each schema of a database.
-          We can create a synonym for a nonexistent table or view. At run time, the system expands the object name to its fully qualified form. If the referenced object does not exist, the system displays an error message.

What is the use of synonym in Netezza:
-          It’s mainly used to reference the tables, views or functions and allows us to create easily typed names (short name) for long object names.

How to view the synonym in NZ database using nzsql.
-  After logging into database using NZSQL then use the below command to display the synonym.
-  \dy

Comments

Post a Comment

Popular posts from this blog

General information about Netezza : Default Error details

General information about Netezza : Default Error details     There are around 140 default error details available in Netezza. For your reference please find below details. ERRORCODE ERRORTEXT 1 Operation failed 2 Interaction aborted 3 Statement aborted 4 Could not serialize - transaction aborted 5 Transaction no longer active 6 Out of memory 7 Incorrect data type 8 Illegal value 9 Internal: SPUs crosstalking 10 Internal pipe I/O failed 11 Cannot determine hostname 12 Rogue SPU trying to register 13 No such table exists 14 No such field exists in table 15 Table already exists 16 Plan already exists in plan dictionary 17 F...
Read more

Minus in Teradata?...

Minus : It will provide the result which one is not matching from both tables... Note: It will provide the not matching result from first select table only. Select Emp_No from Emp Minus Select Emp_no from Emp_Dep;
Read more