Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Generate DDL For a Table
How To:
To generate DDL for a table, follow the steps below:
Step |
Action |
See Also |
---|---|---|
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 |
|
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 |
Select the checkboxes for the appropriate inclusions; for example, to include a 'drop table' command in the script, select the Create Drop SQL checkbox Deselect the checkboxes for inclusions you do not require |
|
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) |
|
Notes:
- In the Corporate, Business and Software Engineering, System Engineering and Ultimate editions of Enterprise Architect, if security is enabled you must have Generate Source Code and DDL permission to generate DDL
- Some checkboxes display only if the appropriate database is defined for the table; for example, IF EXISTS displays only if the database for the table is PostgreSQL, and SEQ_ and _SEQ radio buttons display only if the database for the table is Oracle
- For a PostgreSQL database, you must select the Generate Sequences checkbox to enable auto increment columns to be created
- If generating Oracle sequences, you must always select the Generate Triggers and Generate Sequences checkboxes - this ensures that a pre-insert trigger is generated to select the next sequence value to populate the column; also set the AutoNum property to True in the column properties
- If generating Oracle sequences, to generate the sequence name and trigger name with the syntax SEQ_<sequence_name> and TRG_<trigger_name>, select the SEQ_ option; conversely, to generate them with the syntax <sequence_name>_SEQ and SET_<trigger_name>, select the _SEQ option
Learn More: