Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Execute DDL

The 'Execute DDL' tab provides a mechanism to easily execute generated DDL statements against a live database, and provides instant feedback on their success, all within the Enterprise Architect interface and without the need for other products.

There are two different types of DDL statement that Enterprise Architect can generate and send to the 'Execute DDL' tab:

  • Create DDL statements, created by the Generate DDL screen, and
  • Alter DDL statements, created by the Database Compare window

The Execute DDL functionality requires the Database Builder to have a valid ODBC connection to a live database. This database connection is shared between the SQL Scratch Pad, Database Compare and 'Execute DDL' tabs of the Database Builder.


Open the Database Builder window, then display the 'Execute DDL' tab.


Specialize > Tools > Database Builder > Execute DDL

Execute the DDL

Showing the Execute DDL tab of the Database Builder in Sparx Systems Enterprise Architect.

The 'Execute DDL' tab has these fields and buttons:



1 Execution Queue

Lists the tasks (each with an associated DDL statement) that are yet to be executed. The list has three columns that specify the name of the object involved, the task and the action being performed.

Selecting an item in the list will display the associated DDL statement (in the 'Script' field) for the given task.

2 Script

A text box with SQL syntax highlighting, showing the DDL statement for the selected task.

3 Save

Click on this button to save all the individual DDL statements from both the 'Execution Queue' and the 'Results List' into a single file.

4 Reset Failed Actions

Click on this button to re-queue any failed or skipped tasks from the 'Results List' to the bottom of the 'Execution Queue'.

5 Skip

Click on this button to skip over the next task in the 'Execution Queue' and not execute it. The task will be moved into the 'Results List' and not given a result.

When you click on the Reset Failed Actions button, skipped tasks are returned to the Execution Queue along with any failed tasks.

6 Execute

Click on this button to execute the next task in the 'Execution Queue'. The task is removed from the top of the 'Execution Queue' and added to the end of the 'Results List' with the execution result.

7 Execute All

Click on this button to execute all tasks in the 'Execution Queue'. When execution is complete, the 'Results List' will display the results of each individual task.

8 Results List

Lists the executed tasks with the results of execution for each task. Selecting an item in this list will display the DDL statement that was executed, in the 'Script' field.


In the example used in the earlier section on Database Comparison (when a column and constraint were renamed), if the defaults are used to 'push' the data model changes into the live database the Execute DDL screen is populated with the details shown here.

Showing the Execute DDL tab of the Database Builder, in Sparx Systems Enterprise Architect.

In summary, DDL is generated to drop both the old column and the old constraint (tasks 'Drop Column' and 'Drop Constraint'), then the column and constraint are created with the new names (tasks 'Add Column' and 'Add Constraint') and finally each has their comments/remarks applied (tasks 'Add Constraint - Constraint Comment' and 'Add Column - Column Comment').

Learn more