Generating an SQL DDL file for an existing data object

You can generate an SQL DLL file for a database object. You can use SQL DDL statements to change the structure of the database. For example, you can define a table, change the definition of a table, or remove a table.

After you create data definitions in the Data perspective, you can generate the SQL DDL file for the data object.

To generate an SQL DDL file for an existing data object:

1. Right-click the database node, table, schema, or view objects, and click Generate DDL to open the Generate SQL DDL wizard.

2. Provide the name and target location for the generated file. By default, the file has the same name as the currently selected data object, and placed in the same project.

3. Select whether to use fully qualified names (including the target schemas for the statements).

4. Select whether to generate delimited identifiers. Place quotation marks around the identifiers.

5. Select whether to generate the associated DROP statement for each CREATE statement contained in the resulting script.

6. Select the Open SQL DDL file for editing when done check box to edit the file after it is generated.

7. Click Finish to generate the file.

The SQL DDL script is shown under the target project.

 

Parent topic

Deploying data objects to a database