SQL Server/T-SQL/Constraints/Disable constraint

Sample Code for Disabling a Constraint

   <source lang="sql">

ALTER TABLE MyTable NOCHECK CONSTRAINT FK1_MyTable

</source>