Physical Modeling › Indexes › Create a Unique or Non-Unique Index

Create a Unique or Non-Unique Index

To create a unique or non-unique index

1. In the physical model, right-click a table, and select Indexes.
2. Select New.
3. (Optional) Enter a key group name in the Key Group box.
4. Enter the index name in the Index box.
5. Select one of the following options:
   • To create a unique Alternate Key (AK) type index on the selected table, select the Unique check box.
   • To create a non-unique Inverted Entry (IE) type index on the selected table, clear the Unique check box.
6. Click OK.
7. Select the Members tab.
8. Select a column in the Available Columns list, and click to include the selected column in the Index Members list.
9. Optionally, click or in the Index Members list to move the column up one position or down one position in the index
10. Click OK.

Note: You cannot use the Indexes dialog to reorder columns in a foreign key index.

More information:

Indexes Dialog