Disabled Check Constraint Found

Check constraints are often disabled when bulk loading data into a table to improve performance. It's easy to forget to re-enable them after the event, meaning the check constraint is no longer applied.

Suggested Action

ūüí° Select 'Suggested Script' for an automatically generated script.

  • Re-enable the constraint, if still needed. Note that re-enabling the constraint will cause all rows to be checked against the constraint, so this should be considered when scheduling the SQL.
  • Drop the constraint if no longer needed.

How to Re-Enable Check Constraints

ALTER TABLE dbo.TableName CHECK CONSTRAINT CK_dbo_TableName;

Further Reading

‚ÄčALTER TABLE (Transact-SQL) | Microsoft Docs