Generate DDL

Using Enterprise Architect you can generate DDL from your model for Database Tables, Database Procedures and Database Views. SQL scripts can be generated for a single Table or for the complete contents of a Package. You can also edit the templates that the system uses to generate the DDL.

One option for generating DDL is to generate it directly to the DDL Execution Engine, on the Execute DDL tab of the Database Builder. You can then execute and test the DDL immediately after generating it without having to switch to another tool or facility.

Alternatively, if you generate the DDL to external files, you can view it using the Source Code editors by clicking on the Package in the Project Browser and pressing F12, Ctrl+E or Alt+7. The editor cannot parse DDL, and therefore does not show a structure tree for a DDL file in the left-hand panel of the Source Code window or view.

Learn more

Learning Center topics

·(Alt+F1) | Enterprise Architect | Database Engineering | Generate DDL