Deleting a Unique Constraint

Delete a unique constraint when you want to remove the requirement for uniqueness for values entered in the column or combination of columns included in the constraint expression.

To delete a unique constraint

1. In your database diagram, right-click the table containing the constrained column or columns, then select Indexes/Keys from the shortcut menu.

   -or-

   Open the Table Designer for the table containing the constraint, right-click in the Table Designer, and choose Indexes/Keys from the shortcut menu.

2. Select the unique constraint from the Selected index list.
   
   
3. Choose Delete.

Caution   Choosing Delete will result in an action that cannot be undone without losing all other changes made to the database diagram. To undo this action, close this database diagram or table design window and all other open database diagrams and table design windows without saving the changes.

The constraint is deleted from the database when you save the table or diagram.

See Also

Constraints | Creating a Unique Constraint | Unique Constraints