Table, View, or Procedure Creation

Home | Previous Page | Next Page Data Migration Utilities > The dbschema Utility >

Table, View, or Procedure Creation

>>-+-----------------------+--+---------------------+----------><
   '- -t--+---+--+-table-+-'  '- -t--+-table------+-'
          '-i-'  +-view--+           +-view-------+
                 '-all---'           +-+-p-+--all-+
                                     | '-f-'      |
                                     '-all--------'

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

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