Disabled Check Constraint

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

šŸ’” Aireforge Advisor can automatically generate a script for this.

  • 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