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:
-
On the Workspace home page, click the SQL Workshop.
-
Click Utilities.
-
Click Generate DDL.
The Generate DDL page appears.
-
Click Create Script.
The Generate DDL Wizard appears.
-
Select a database schema and click Next.
-
Define the object type:
-
Output - Specify an output format. Select either Display Inline or Save As Script File.
-
Check All - Select this option to include all object types for which to generate DDL.
-
Object Type - Select the object types for which to generate DDL.
-
To select object names for the selected object types, click Next and follow the on-screen instructions.
-
-
Click Generate DDL.
See Also:
-
Oracle Database SQL Language Reference for information about DDL statements
-
Data Dictionary and Dynamic Performance Views in Oracle Database Concepts for information about the data dictionary
Parent topic: Using SQL Workshop Utilities