Forward Engineer/Alter Script › Select Schema Generation Options › Define Schema Generation Table Options

Define Schema Generation Table Options

To define schema generation table options

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

   The Forward Engineer Schema Generation dialog opens on the Options tab.

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

   CREATE TABLE

   Include a Create Table statement for each selected table in the generated schema.

   Entity Integ

   Include SQL statements that create constraint rules for each table.

   DROP TABLE

   Execute DROP TABLE or DELETE TABLE statements before executing CREATE TABLE statements when generating the schema. A DROP TABLE statement is executed for each CREATE TABLE statement in the schema.

   Physical Storage

   Include physical storage objects and parameters in the generated schema.

   Note: This option is not available for SQL Azure.

   Table CHECK

   Include SQL statements that create constraint rules for each table.

   Pre-Script

   Execute prescripts attached to a table immediately before generating the table.

   Post-Script

   Execute postscripts attached to a table immediately after generating the table.

   Table Validation

   Include any validation rules associated with tables in the generated schema as table-level check constraints. This option is only available in Progress when you choose to generate the schema using the Progress 4GL option.

   CREATE ALIAS

   Include any user-defined table alias names in the generated schema. This option is available for DB2 LUW and DB2 z/OS.

   DROP ALIAS

   Include statements that drop previously defined alias table names. A DROP statement is executed for each CREATE alias statement in the generated schema. This option is available for DB2 LUW and DB2 z/OS.

   Create Macro

   Include Teradata macro statements in the generated schema.

   Drop Macro

   Include statements that drop previously defined Teradata macros. A DROP statement is executed for each CREATE macro statement in the generated schema.

   CREATE SYNONYM

   Include your defined synonym table names in the generated schema.

   Drop SYNONYM

   Include statements that drop previously defined synonym table names. A DROP statement is executed for each CREATE synonym statement in the generated schema.

   Create Procedure

   Include any table-level stored procedures in the generated schema.

   Drop Procedure

   Include statements that drop previously defined table-level stored procedures in the generated schema. A DROP statement is executed for each CREATE procedure statement in the generated schema.

   Partitions

   Include partition clause statements in the generated schema. This option is only available for Oracle.

   Override Owner

   Override the owner name indicated either in the Table Editor, or in the Model Editor, Defaults tab. When you click the Override Owner option, a new dialog opens, in which you indicate the owner name to use for the override. When you generate the schema during forward engineering, this name overrides other owner names you previously indicated.

   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.

Note: When you generate a schema on the server, any changes made to table properties, such as changing the table's name, columns, or relationships, are not updated on the server unless you select the DROP TABLE and CREATE TABLE options.