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:
Type | Index definition | Comment definition | Definition SQL statements to be generated |
---|---|---|---|
Base table | Specified | Specified | CREATE TABLE CREATE INDEX COMMENT |
Not specified | CREATE TABLE CREATE INDEX | ||
Not specified | Specified | CREATE TABLE COMMENT | |
Not specified | CREATE TABLE | ||
View table | -- | Specified | CREATE VIEW COMMENT |
Not specified | CREATE VIEW | ||
Trigger | -- | -- | CREATE TRIGGER |
Stored procedure | -- | -- | CREATE PROCEDURE |
Legend: --: Not applicable