DDL File Editor

This dialog box is displayed after you select a relational model for which to generate Data Definition Language (DDL) statements. It is also displayed if you click View, then DDL File Editor; if you click File, then Export, then DDL File; or if you click the Generate DDL toolbar icon.

Physical model (list): Select the physical model (type of database) for which to generate DDL statements. Example: Oracle 11g

Generate: Displays the DDL Generation Options dialog box. After you select the options, the resulting DDL statements are displayed in this dialog box.

Clear: Clears the display of generated DDL statements. If the generated DDL code does not meet your needs, click Clear, make any necessary changes to the model, and start the generation process again.

Find: Displays a box for finding a text string in the generated DDL statements.

Save: Lets you save the generated DDL statements to a script file.


Note:

You should review, test, and (if necessary) edit any DDL that is generated before it is run against any database.

This is especially important if you import from the data dictionary of a third-party database and then export or generate DDL for an Oracle Database physical model.