Udostępnij za pośrednictwem


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 (Modify in SP1 or earlier). 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.

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.

See Also

Concepts

CHECK Constraints

Other Resources

Working with Constraints (Visual Database Tools)
Working with Keys (Visual Database Tools)
Indexes/Keys Dialog Box (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance