Synonym creation
The dbschema -s command generates information about synonym creation.
The following syntax diagram fragment shows the creation of synonyms.
Element | Purpose | Key Considerations |
---|---|---|
-s ownername | Displays the CREATE SYNONYM statements owned by ownername | None. |
-s all | Displays all CREATE SYNONYM statements for the database, table, or view specified | None. |
Output from dbschema that ran with the specified
option
-s alice
might appear as the following example
shows: CREATE SYNONYM 'alice'.cust FOR 'alice'.customer
For more information about the CREATE SYNONYM statement, see the HCL OneDB™ Guide to SQL: Syntax.