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[Figure]SpecifiedCREATE VIEW
COMMENT
Not specifiedCREATE VIEW
Alias table[Figure][Figure]CREATE ALIAS
Trigger[Figure][Figure]CREATE TRIGGER
Stored procedure[Figure][Figure]CREATE PROCEDURE

Legend: [Figure]: Not applicable