How to: Delete Unique Constraints (Visual Database Tools)

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 Object Explorer, right-click the table with the unique constraint, and click Design. The table opens in Table Designer.

  2. From the Table Designer menu, click Indexes/Keys.

  3. In the Indexes/Keys dialog box, select the unique key in the Selected Primary/Unique Key and Index list.

  4. Click Delete.

    The constraint is removed from the database when you save the table.