Previous Topic: Define Schema Generation Trigger OptionsNext Topic: Display Schema Generation 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.