Справочник Пользователя для IBM 000-8697
Utilities
7-35
Specify a Table, View, or Procedure
Specify a Table, View, or Procedure
If you specify
all
for the name of the procedure, dbschema displays all
CREATE PROCEDURE
statements.
If you specify
all
for the table name (or view name), dbschema displays the
SQL
statements for all database tables and views.
For more information about the
CREATE PROCEDURE
statement, see
IBM I
nformix
G
uide to
SQL: R
eference.
-f procedure
specifies the name of the procedure for which you want
dbschema
dbschema
to output
CREATE PROCEDURE
statements.
-t view name
directs dbschema to limit the
SQL
statement output to only
those statements needed to replicate the specified view.
-t table name
directs dbschema to limit the
SQL
statement output to only
those statements needed to replicate the specified table.
Tables, Views, or
Procedures
-t
-t
-f
table name
view name
procedure