Справочник Пользователя для IBM 000-8697

Скачать
Страница из 702
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
 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