Use the Generate DDL wizard to generate DDL
for any of the objects within a schema in a data design project. You can run
the DDL on a data server to populate a metadata catalog with tables, indexes,
views, and stored procedures. You can also choose just to save the DDL to
a file.
Options page
Use this page to specify the types
of SQL DDL statements that you want to generate. Also, specify whether to
use fully qualified names and quoted identifiers.
- Fully qualified names
- Select to qualify the names of all of the objects
with the schema for the object.
- Quoted identifiers
- Select to generate double quoted identifiers for
all statements.
- DROP statements
- Select to generate DROP statements for all of
the objects for which you choose to generate DDL statements.
- CREATE statements
- Select to generate CREATE statements for all of
the objects for which you choose to generate DDL statements.
- COMMENT ON statments
- Select to generate COMMENT ON statements for all
of the objects for which you choose to generate DDL statements.
- GRANT statements
- Select to generate GRANT statements for all of
the objects for which you choose to generate DDL statements.
Objects page
Use this page to select the types of
objects for which you want to generate SQL DDL statements. The selection on
this page depends on which object you right-clicked to open the wizard.
- Tables
- Select to generate DDL for tables, if the object
that you right-clicked to open the wizard is a schema with one or more tables
in it or a table.
- Indexes
- Select to generate DDL for indexes, if the object
that you right-clicked to open the wizard is a table with one or more indexes
on it.
- Primary key constraint
- Select to generate DDL for primary key constraints,
if the object that you right-clicked to open the wizard is a table with a
primary key constraint defined on it.
- Views
- Select to generate DDL for views, if the object
that you right-clicked to open the wizard is a schema with one or more views
in it or a view.
- Stored procedures
- Select to generate DDL for stored procedures,
if the object that you right-clicked to open the wizard is a schema with one
or more stored procedures in it or a stored procedure.
Save and Run DDL page
Use this page to review the
generated DDL. You can run the DDL on a data server to populate its metadata
catalog with the objects that are defined by the DDL. You can also choose
to edit the DDL. The DDL is saved in a .sql file in the SQL Scripts folder
in the project.
- Folder
- Displays the folder for the project in which the
objects that are defined by the DDL are located. By default, the .sql file
that contains the DDL is saved in the SQL Scripts folder
in this project. You can select a different project in which to save the DDL.
- File name
- Type a name for the .sql file that will contain
the DDL.
- Preview DDL
- Displays the DDL so that you can review it.
- Statement terminator
- The only supported terminator is the semicolon.
- Run DDL on server
- Select to run the DDL on a data server when you
click Finish. A connection to the data server must
exit.
- Open DDL file for editing
- Select to open the DDL in a text editor within
Classic Data Architect when you click Finish.
Summary page
Use this page to review the settings
that you chose for the DDL. Click Finish to
run the DDL, edit the DDL, or both.