Physical Modeling › Columns › Columns Dialog › Define Column Index Membership

Define Column Index Membership

Use the Index tab in the Columns dialog to manage index membership for the selected column.

Note: Changing primary key index assignments has the following additional effects:

• The column is moved to the key area of the table if you add the column to the primary key index.
• The column is moved to the non-key area of the table if you remove the column from the primary key index.

To define column index membership

1. Click Columns on the Model menu.

   The Columns dialog opens.

2. Click the Index tab.

   The Index tab opens.

3. Select from the following options and click OK:

   Index Membership

   Lets you assign the selected column to an index that is attached to the current table. This field displays the primary key, alternate key, foreign key, and inversion entry indexes in which the selected column is a member. Select the check box next to an index name to assign the selected column to that index. Clear the check box next to an index name to remove the column from the index.

   Show FK Indexes

   Specifies to display foreign key indexes in the Index Membership list. Clear the check box to hide foreign key indexes.

   Index membership is defined for the column and the Columns dialog closes.

More information:

Indexes Dialog