Utilities 7-35

Specify a Table, View, or Procedure

Specify a Table, View, or Procedure
If you specifyall for the name of the procedure, dbschema displays all
CREATEPROCEDURE statements.
Ifyou specify all for the table name (or view name), dbschema displays the
SQL statements for all database tables and views.
For more information about theCREATE PROCEDURE statement, see
IBMInformix Guide to SQL: Reference.
-fprocedure specifies the name of the procedure for which you want
dbschema to output CREATEPROCEDURE statements.
-tview name directsdbschema to limit the SQL statement output to only
those statements needed to replicate the specified view.
-ttable name directsdbschema 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