How to create a UNIQUE constraint on an existing table (Enterprise Manager)

To create a UNIQUE constraint on an existing table

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, and then click Design Table.
4. Right-click any row; then click Properties.
6. On the Indexes/Keys tab, click New.
7. In the Column name list, select the columns that are part of the UNIQUE constraint.
8. Select Create UNIQUE to make this index a unique constraint.

See Also

Creating and Modifying UNIQUE Constraints