Generate DDL For an Object

Single File

If you want to store the script in a file, select this radio button and type in or browse for (click on the button) the file path and name under which to create the script.

Generate to DDL Execution Engine

(The default selection.) Generates the DDL to the Execute DDL tab of the Database Builder, opening the Database Builder at that tab if it is not already displayed.

The DDL Execution Engine provides the facilities for executing the generated SQL script and responding to errors in execution immediately, without having to create an external file and load it into another tool.

 
Generate and Execute DDL

Generate

After you have defined the generation parameters on the Options and Format tabs, click on this button to create the DDL.

View

If you have generated the DDL to an external file, click on this button to view the output.

The viewer defaults to the Enterprise Architect default code editor. However, you can define an alternative default DDL editor on the Options dialog (Tools | Options | Source Code Engineering | Code Editors).

Editing Source Code

Options - Code Editors

Close

Click on this button to close the dialog. If you did not generate the DDL, this button also abandons DDL generation for the object.

Option Checkboxes

Select the checkbox for each type of object associated with the selected object that you want to include in the DDL generation.

Deselect the checkboxes for inclusions you do not require.

Comment Level

To include comments in the DDL, click on the drop-down arrow and select the appropriate level.

For example, select Column to include comments on columns, or All to include comments on all structures.

Create Drop SQL

Select the checkbox if you want to include a 'drop Table' command for each Table in the script.

IF EXISTS

Select the checkbox to include IF EXIST statements in the generated DDL if the current DBMS supports them.

Use Database

Select the checkbox and type in the name of the database, to include the keywords Use {database} at the beginning of the generated DDL so that the DBMS executes all the statements against the specified database.

Use Alias if Available

Select the checkbox to use object Aliases instead of the object names, where such Aliases are specified.

Use NULL for nullable columns

Select the checkbox to set columns that are not set to NOT NULL to specifically have the keyword NULL defined against them in the generated DDL, if the DBMS supports this.

Separate constraint definition from table definition

Select the checkbox to define constraints (such as Primary Keys, Foreign Keys and Unique Constraints) in their own ALTER TABLE statements rather than within the CREATE TABLE statement in the DDL.