Filter
Top Products
7-32 IBM Informix OnLine Database Server Administrator’s Guide
dbschema: Output SQL Statements
dbschema: Output SQL Statements
Use the dbschema utility to display the SQL statements required to replicate
a database or a specific table, view, or procedure. Options enable you to
perform the following activities:
■ Display CREATE SYNONYM statements, by owner, for a database or
for a specific table.
■ Display all GRANT privilege statements that affect a specified user or
that affect all users for a database or for a specific table.
■ Save the output to a file.
You must be the DBA or have Connect or Resource privilege to the database
before you can run dbschema on it.
You can display the software version number by executing dbschema -V.
Syntax
If you do not supply a filename, dbschema sends output to the screen.
You can use the OnLine syntax database@dbservername to specify the database.
Specifying a database server name allows you to choose a database on
another server as your current database if you have installed IBM Informix
STAR.
Synonyms
p. 7-33
Privileges
p. 7-34
dbschema
filename
Tables,
Views, or
Procedures
p. 7-35
-d database
-d database specifies the database to which the schema applies.
filename specifies the filename that will contain the dbschema output.