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

Define Schema Generation Other Options

Use the Other Options section of the Options tab in the Forward Engineer Schema Generation dialog to define schema generation options in addition to the options provided by physical object.

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

   Constraint Name

   Include the constraint names in the generated schema.

   Comments

   Include table and column comments in the generated schema. This option is available for all target servers, so you can include the comment in the DDL script either for documentation or for portability of the definitions from one model to another.

   Note: Do not generate comments to your target server if the target server does not support them. Certain target databases, such as SQL Server 2008, require that an object owner be specified in the model in order to generate the object's comments to the server.

   Quote Names

   Insert quotation marks around table and column names in the generated schema.

   Owner

   Include the individual table owner in the CREATE TABLE statement in the generated schema.

   Wrap File Output

   Format the generated DDL so that no line is greater than 72 characters. This option is only available for DB2 z/OS.

   Replace Tabs with space

   Replace all tabs in the generated DDL with spaces. This option is only available for DB2 z/OS.

   Use Labels for Logical Names

   Include labels for tables based on entity names in the generated schema. This option is only available for DB2 iSeries.

   Qualify Names

   Generate table and views to a particular area of the database. This option is only available for DB2 iSeries.

   erwin Exceptions

   Create a user-defined error and associated messages to use in stored procedures and triggers. This option is only available for Informix.

   LibRefs

   A library reference in SAS is a name associated with the physical name of a SAS data library. When you select this check box and a new SAS data set is created, the libref points to the SAS data library where the file is stored. When you reference an existing SAS data set, the libref indicates the data library where the SAS system should look for the file. This option is only available for SAS.

   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.