Export (0) Print
Expand All

Delete Check Constraints

You can delete a check constraint in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL. Deleting check constraints removes the limitations on data values that are accepted in the column or columns included in the constraint expression.

In This Topic

Security

Permissions

Requires ALTER permission on the table.

Arrow icon used with Back to Top link [Top]

To delete a check constraint

  1. In Object Explorer, expand the table with the check constraint.

  2. Expand Constraints.

  3. Right-click the constraint and click Delete.

  4. In the Delete Object dialog box, click OK.

Arrow icon used with Back to Top link [Top]

To delete a check constraint

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    ALTER TABLE dbo.DocExc 
    DROP CONSTRAINT CHK_ColumnD_DocExc;
    GO
    

For more information, see ALTER TABLE (Transact-SQL).

Arrow icon used with Back to Top link [Top]

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

Community Additions

ADD
Show:
© 2014 Microsoft