Disable and Enabling the Constraints in SQL – SQL Server Tutorial

DISABLE AND ENABLING THE CONSTRAINTS  :-

• If the constraint is disabled, the constraint is exists in the table, but it will not work.

Syntax  :-        no check

Example  :-   alter table emp22

                              No check

                             Constraint ck_sal_emp22

Example :-    alter emp22

                             Check

                             Constraint ck_sal_emp22 ( Enable: Syntax:Check)