IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

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.

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 I

nformix

STAR

.

Synonyms

p.

Privileges

p.

dbschema

Tables,

Views, or

Procedures

p.

-d database

specifies the database to which the schema applies.

specifies the filename that will contain the dbschema output.