How to create a unique index using a database diagram (Enterprise Manager)

To create a unique index using a database diagram

1. Open a database diagram.
2. Right-click the table to index, and then click Properties.
3. Click the Indexes/Keys tab.
4. Click New.

   The Selected index list displays the system-assigned name of the new index.

5. Under Column name, click the columns to index.

   You can select up to 16 columns. For optimal performance, select only one or two columns per index.

6. Select the Create UNIQUE check box.
7. Click the Index option.
8. Select the Ignore duplicate keys check box if you want to ignore new or updated data that would create a duplicate key in the index (with the INSERT or UPDATE statement).

See Also