Filter
Top Products
Utilities 7-33
Include Synonyms
All SERIAL fields included in CREATE TABLE statements displayed by
dbschema have a starting value of 1, regardless of their original starting
value.
The dbschema utility uses the owner.object convention when it generates any
CREATE TABLE, CREATE INDEX, CREATE SYNONYM, CREATE VIEW, CREATE
PROCEDURE
, or GRANT statements, and when it reproduces any unique or
referential constraints. As a result, if you use the dbschema output to create
a new object (table, index, view, procedure, constraint, or synonym), the new
object is owned by the owner of the original object. If you want to change the
owner of the new object, you must edit the dbschema output before you run
it as an SQL script.
For more information about the CREATE TABLE, CREATE INDEX, CREATE
SYNONYM, CREATE PROCEDURE, GRANT
, and CREATE VIEW statements, see
IBM Informix Guide to SQL: Reference.
Include Synonyms
If you specify all for ownername, dbschema displays all CREATE SYNONYM
statements for the database, table, or view specified.
Output from 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 the CREATE SYNONYM statement, see
IBM Informix Guide to SQL: Reference.
-s ownernamedirects dbschema todisplay the CREATE SYNONYM statements
owned by ownername.
Synonyms
-s ownername