How to delete a CHECK constraint (Enterprise Manager)

To delete a CHECK constraint

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, and then click Design Table.
4. Right-click the column name from which to delete the CHECK constraint; then click Properties.
5. On the Tables tab, in the Selected constraint list, select the name of the CHECK constraint.
6. Click Delete.

See Also

Creating and Modifying CHECK Constraints