Creating DDL Files

This topic describes the procedure to create and associate DDL script files to database objects.

  1. From the DB Browser pane, double-click the object from the database tree structure to open it in the SQL Editor window.


    Database object open in SQL editor pane

  2. From the editor toolbar menu, click the DDL File icon and select Create New. If DDL files are present in the project scope, you can select Attach Files option and select the DDL file from the project folder to attach to the database object.
  3. Select the Project folder location where you want to save the new DDL file. The new DDL file is created and opens in a new tab on the editor window. By default, the created DDL file is attached to the object.


    New DDL File created

    The DDL file extension is based on the database object which it is mirroring. Changes made to the code in the database object are reflected on the attached DDL script. You can commit the attached DDL file to commit your code changes.