9.1.4 Generation of a definition SQL

A definition SQL is generated and output to a file on the basis of the export file definition information. The following table lists the definition SQL statements that can be generated:

TypeIndex definitionComment definitionDefinition SQL statements to be generated
Base tableSpecifiedSpecifiedCREATE TABLE
CREATE INDEX
COMMENT
Not specifiedCREATE TABLE
CREATE INDEX
Not specifiedSpecifiedCREATE TABLE
COMMENT
Not specifiedCREATE TABLE
View table--SpecifiedCREATE VIEW
COMMENT
Not specifiedCREATE VIEW
Trigger----CREATE TRIGGER
Stored procedure----CREATE PROCEDURE

Legend: --: Not applicable