Synonym creation

The dbschema -s command generates information about synonym creation.

The following syntax diagram fragment shows the creation of synonyms.


Synonyms

|-- -s--+-ownername-+-------------------------------------------|
        '-all-------'

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 IBM® Informix® Guide to SQL: Syntax.