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.


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 Customizing Development Settings in Visual Studio.

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.

Community Additions