Share via


How to: Delete Unique Constraints

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.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

To delete a unique constraint

  1. In Server Explorer, select the table with the unique constraint, and from the Database menu click Open Table Definition.

  2. The table opens in Table Designer.

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

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

  5. Click Delete.

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

See Also

Reference

Indexes/Keys Dialog Box

Other Resources

Working with Constraints

Working with Keys