Generate DDL

 Return to Introduction  Previous page  Next page

Enterprise Architect can generate simple DDL scripts to create the tables in your model.

Generate DDL

To generate DDL, follow the steps below:

1.In the diagram, right-click on the table for which to generate DDL. The context menu displays.
2.Select the Generate DDL option. The Generate DDL dialog displays.
 
GenerateDDL
 
3.In the Path field, use the [...] (Browse) button to select the filename of the script to create.
4.To include comments in the DDL, in the Comment Level field select the appropriate level. For example, Column for comments on columns, or All for comments on all structures.
5.To include a 'drop table' command in the script, select the Create Drop SQL checkbox.
6.To create the DDL, click on the Generate button.
7.To view the output, click on the View button (you must configure a DDL viewer in the Local Settings dialog first).