Delete Check Constraints


Applies To: SQL Server 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

You can delete a check constraint in SQL Server 2016 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



Requires ALTER permission on the table.

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.

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   

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

Community Additions