Prev | Next |
DDL Options in Templates
The DDL Generation Options macros provide a convenient way for the DDL templates to access the generation options.
This list identifies and briefly describes each of the available option macros. Each option has a value of either 'T' for true or an empty string for false.
ddlGenerateToExecuteEngine
Directs the generated DDL to the Execution Engine.
ddlOptionColumnComments
Include column comments in the generated DDL.
ddlOptionGenerateCheck
Include Check constraints in the generated DDL.
ddlOptionGenerateDrop
Include DROP statements in the generated DDL.
ddlOptionGenerateForeign
Include Foreign Keys in the generated DDL.
ddlOptionGenerateFunction
Include Functions in the generated DDL.
ddlOptionGenerateIndex
Include Indexes in the generated DDL.
ddlOptionGenerateLengthSemantic
(Oracle only) Include length semantics syntax on text columns in the generated DDL.
ddlOptionGenerateNullable
Include the keyword NULL against each column if it hasn't been flagged as a NOT NULL column in the generated DDL.
ddlOptionGeneratePackage
(Oracle only) Include Packages in the generated DDL.
ddlOptionGeneratePrimary
Include Primary Key constraints in the generated DDL.
ddlOptionGenerateProcedure
Include Procedures in the generated DDL.
ddlOptionGenerateSeparateConstraint
Generate Table constraints separately to the CREATE TABLE statement; that is, using an ALTER TABLE statement.
Note: Some DBMSs do not support separate constraints in all conditions.
ddlOptionGenerateSequence
Include Sequences in the generated DDL.
ddlOptionGenerateTable
Include Tables in the generated DDL.
ddlOptionGenerateTableProperty
Include extended properties on Tables in the generated DDL.
ddlOptionGenerateTrigger
Include Table Triggers in the generated DDL.
ddlOptionGenerateUnique
Include Unique Constraints in the generated DDL.
ddlOptionGenerateView
Include Views in the generated DDL.
ddlOptionHeaderComments
Include header comments in the generated DDL.
ddlOptionTableComments
Include Table comments in the generated DDL.
ddlOptionUseAlias
Use Aliases instead of Names for all objects (object components) as specified on the Generate DDL screen.
ddlOptionUseDatabaseName
Include the USE DATABASE statement at the beginning of each generated file.
ddlUseAlias
Use Aliases instead of Names for all objects (object components) as specified on the Database Builder 'Database Compare' tab.