Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Delete Check Constraints (Visual Database Tools)

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.

To delete a check constraint

  1. In Object Explorer, right-click the table with the check constraint, and click Design. The table opens in Table Designer.

  2. From the Table Designer menu, click Check Constraints.

  3. In the Check Constraints dialog box, select the constraint in the Selected Check Constraint list.

  4. Click the Delete button.


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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft