Previous Topic: Define Schema Generation View OptionsNext Topic: Define Schema Generation Referential Integrity Options


Define Schema Generation Index Options

To define schema generation index 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 Index
    Primary Key (PK)

    Create an index on the primary key in each table.

    Alternate Key (AK)

    Create an index for each alternate key in each table.

    Foreign Key (FK)

    Create an index for each foreign key in each table.

    Inversion Entry (IE)

    Create an index on the inversion entry in each table.

    Drop Index
    Primary Key (PK)

    Drop primary key indexes in each table.

    Alternate Key (AK)

    Drop alternate key indexes in each table.

    Foreign Key (FK)

    Drop foreign key indexes in each table.

    Inversion Entry (IE)

    Drop inversion entry indexes in each table.

    CLUSTERED or CLUSTERED HASHED

    Create a clustered or clustered hashed index in the generated schema.

    Physical Storage

    Include index physical storage information in the generated schema.

    Note: This option is not available for SQL Azure.

    PRIMARY

    Include a UNIQUE PRIMARY INDEX clause in the generated schema.

    Write PRG File

    Create an ASCII file that you must run on the target server to create the index.

    Partitions

    Create partitioned indexes. This option is only available for Oracle.

    Override Owner

    Override the owner name indicated either in the Index 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.