Table, view, or procedure creation

Several dbschema options generate information that shows the creation of tables, views, and procedures.

The following syntax diagram shows the creation of tables, views, and procedures.


Tables, Views, or Procedures:

|--+----------------+--+---------------------+------------------|
   '- -t--+-table-+-'  '- -t -+-table------+-'   
          +-view--+           +-view-------+     
          '-all---'           +-+-p-+--all-+     
                              | '-f-'      |     
                              '-all--------'

Element	Purpose	Key Considerations
-f all	Limits the SQL statement output to those statements that replicate all functions and procedures	None.
-f *function*	Limits the SQL statement output to only those statements that replicate the specified function	None.
-f *procedure*	Limits the SQL statement output to only those statements that replicate the specified procedure	None.
-ff all	Limits the SQL statement output to those statements that replicate all functions	None.
-fp all	Limits the SQL statement output to those statements that replicate all procedures	None.
-t *table*	Limits the SQL statement output to only those statements that replicate the specified table	None.
-t *view*	Limits the SQL statement output to only those statements that replicate the specified view	None.
-t all	Includes in the SQL statement output all statements that replicate all tables and views	None.

For more information about the CREATE PROCEDURE and CREATE FUNCTION statements, see the IBM® Informix® Guide to SQL: Syntax.