Creating an SQL DDL script

You can create an SQL DDL script to define or work with existing database objects.

To create an SQL DDL script:

  1. Click File > New > Other , select SQL/DDL Script under the Data node, then click Next If you do not see the Data node or the New SQL/DDL Script wizard in the list, select the Show All Wizards check box.

  2. Specify the folder to hold the SQL resource. This folder name must exist in the workbench.

  3. In the SQL script file name field, type the name of the SQL script file that you want to create. For the script file to be displayed in the Data Definition view, it must end with the file extension .sql.

  4. Select the default contents (automatically generated sample content) for the file.

  5. Optional: Select the Open file for editing when done check box to edit the file after it is generated.

  6. Click Finish.

The file is added to the project that you selected. The file appears in the Data Definition view if your Data Definition filter preference for that folder does not exclude SQL scripts.

When you edit SQL resources, you can get assistance with your coding by pressing Ctrl+Space on your keyboard to activate content assist.

 

Parent topic

Deploying data objects to a database