How to: Delete Check Constraints
Delete a check constraint when you want to remove the limitations on data values that are accepted in the column or columns included in the constraint expression.
Note
Some databases have different functionality for check constraints. Consult your database documentation for details about how your database works with check constraints.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To delete a check constraint
In Server Explorer, select the table with the check constraint, and from the Database menu click Open Table Definition.
The table opens in Table Designer.
From the Table Designer menu, click Check Constraints.
In the Check Constraints dialog box, select the constraint in the Selected Check Constraint list.
Click the Delete button.
Note
To undo this action, close the table without saving the changes. Choosing Delete cannot be undone without losing all other changes made to the database diagram.
The constraint is deleted from the database when you save the table.