Previous Next JavaScript must be enabled to correctly display this content

## 5.6 Generating DDL

Generate data definition language (DDL) statements from the Oracle data dictionary.

You can use these scripts to create or re-create database schema objects. The scripts can be generated to display inline or saved as a script file. You can generate the create scripts for all objects for a specific schema, specific object types, or specific objects.

To generate a DDL statement:

1. On the Workspace home page, click the SQL Workshop.

2. Click Utilities.

3. Click Generate DDL.

   The Generate DDL page appears.

4. Click Create Script.

   The Generate DDL Wizard appears.

5. Select a database schema and click Next.

6. Define the object type:

   1. Output - Specify an output format. Select either Display Inline or Save As Script File.

   2. Check All - Select this option to include all object types for which to generate DDL.

   3. Object Type - Select the object types for which to generate DDL.

   4. To select object names for the selected object types, click Next and follow the on-screen instructions.

7. Click Generate DDL.

See Also:

- Oracle AI Database SQL Language Reference for information about DDL statements

- Data Dictionary and Dynamic Performance Views in Oracle AI Database Concepts for information about the data dictionary

Parent topic: Using SQL Workshop Utilities