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

Define Schema Generation Column Options

To define schema generation column 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:

   Attribute Integ

   Include constraint statements that are defined for each column in the generated schema.

   Column CHECK

   Include constraint statements that are defined for each column in the generated schema.

   Default or DEFAULT Value

   Include default value statements that are defined for each column in the generated schema.

   Physical Order

   By default this is selected to preserve the physical order of the columns in the generated schema. If you clear this check box, the ordinary column order is used in the generated schema. Note that the column order is used to establish the Primary Keys, Alter statements, and so on in the generated schema even if you select the Physical Order check box in the Column Options.

   sp_bindrule

   Include a statement that binds the constraint rule to the column in the generated schema.

   sp_bindefault

   Include a statement that binds the default constraint rule to the column in the generated schema.

   Validation

   Include the validation rule for the column in the generated schema.

   FIELDPROC/Check

   Include statements for column-level check constraints in the generated schema to DB2 z/OS. You can define how column-level check constraints are generated in the schema (for example, as FIELDPROC statements or as CHECK statements) using the Validation Rules dialog.

   Initial Value

   Include a statement assigning column initial values in the generated schema.

   Heading

   Include a statement assigning column headings in the generated schema.

   Label

   Include a statement assigning column labels in the generated schema.

   Column Label

   Include a statement assigning column labels in the generated schema.

   Use Logical Names

   Generate the column label as the logical attribute name. This option is only available for DB2 iSeries.

   Check Constr

   Include constraint statements that are defined for each column in the generated schema.

   Use Distinct Type

   Include the user-defined distinct type for the column in the schema statement. This option is only available for DB2 UDB.

   BETWEEN

   Include the validation rule for the column in the schema statement. This option is only available for Teradata.

   Title

   Include a statement assigning column titles 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.

More information:

Example - Physical or Column Order in Forward Engineering