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:

1?   -t
2.1 table
2.1 view
2.1 all?   -t 
2.1 table
2.1 view
2.1 
2.2.1 p
2.2.1 f
2.1 all
2.1 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 HCL OneDB™ Guide to SQL: Syntax.