Utilities 7-33

Include Synonyms

AllSERIAL fields included inCREATE TABLE statements displayed by
dbschema have a starting value of 1, regardless of their original starting
value.
Thedbschema utility uses the owner.object convention when it generates any
CREATETABLE,CREATE INDEX,CREATESYNONYM,CREATE VIEW,CREATE
PROCEDURE, orGRANT statements, and when it reproduces any unique or
referentialconstraints. As a result, if you use the dbschema output to create
anew object (table, index, view, procedure, constraint, or synonym), the new
objectis owned by the owner of the original object. If you want to change the
ownerof the new object, you must edit the dbschema output before you run
it as anSQL script.
For more information about theCREATE TABLE,CREATE INDEX,CREATE
SYNONYM,CREATE PROCEDURE, GRANT, and CREATEVIEW statements, see
IBMInformix Guide to SQL: Reference.
Include Synonyms
Ifyou specify all for ownername,dbschema displays all CREATE SYNONYM
statements for the database, table, or view specified.
Outputfrom dbschema that is executed with the specified option -s alice
might appear as follows:
CREATE SYNONYM "alice".cust FOR "alice".customer
For more information about theCREATE SYNONYM statement, see
IBMInformix Guide to SQL: Reference.
-sownername directs dbschema to display the CREATE SYNONYM statements
owned byownername.
Synonyms
-sownername