Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
In your database diagram, right-click the table containing the constraint, then select Properties from the shortcut menu.
-or-
Open the Table Designer for the table containing the constraint, right-click in the Table Designer, and choose Properties from the shortcut menu.
Choose the Check Constraints tab.
Select the constraint from the Selected constraint list.
Choose Delete.
Caution Choosing Delete will result in an action that cannot be undone without losing all other changes made to the database diagram. To undo this action, close this database diagram and all other open database diagrams without saving the changes.
The constraint is deleted from the database when you save the table or diagram.
See Also
Attaching a New Check Constraint to a Table or Column | Check Constraints | Constraints