Working with Data Models › Forward Engineer/Alter Script › Select Schema Generation Options › Define Schema Generation Schema Options

Define Schema Generation Schema Options

To define schema generation schema options

1. Click Forward Engineer, Schema... on the Actions menu.

   The Schema Generation dialog opens on the Options tab.

2. Select the name of the current option set and choose from the following options:

   <PHYSICAL OBJECT>

   Include physical object definitions in the generated schema.

   Create Procedure

   Include model-level stored-procedures in the generated schema.

   Drop Procedure

   Include DROP PROCEDURE statements in the generated schema.

   Create Macro

   Include CREATE MACRO statements in the generated schema. This option is available only for Teradata.

   Drop Macro

   Include DROP MACRO statements in the generated schema. This option is available only for Teradata.

   Pre-Script

   Execute prescripts attached to the schema before generating the schema.

   Post-Script

   Execute postcripts attached to the schema after generating the schema.

   DISTINCT TYPE

   Include CREATE DISTINCT statements for each DB2 LUW user-defined datatype in the generated schema. You define DB2 LUW user-defined datatypes in the Domain editor.

   TABLESPACE

   Include CREATE TABLESPACE statements in the generated schema.

   Rollback Segment

   Include CREATE ROLLBACK SEGMENT statements in the generated schema.

   DATABASE

   Include CREATE DATABASE statements in the generated schema.

   SEGMENT

   Include CREATE SEGMENT statements in the generated schema.

   CREATE DBSPACE

   Include CREATE DBSPACE statements in the generated schema.

   sp_addtype

   Include sp_addtype statements in the generated schema.

   Create Rule

   Include validation rules definitions in the generated schema.

   Create Default

   Include default value definitions in the generated schema.

   Click Generate to start the schema generation process for forward engineering or alter script generation or OK to save the changes and close the dialog.