How to delete a UNIQUE constraint (Enterprise Manager)
To delete a UNIQUE constraint
- Expand a server group; then expand a server.
- Expand Databases, expand the database in which the table belongs, and then click Tables.
- In the details pane, right-click the table, and then click Design Table.
- Right-click any row; then click Properties.
- On the Indexes/Keys tab, in the Selected index list, select the name of the index that enforces the UNIQUE constraint.
- Click Delete.
See Also
Creating and Modifying UNIQUE Constraints
(c) 1988-98 Microsoft Corporation. All Rights Reserved.