Forward Engineer/Alter Script › Select Schema Generation Options › Define Schema Generation Index 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.