SQL Server/T-SQL/Constraints/Disable constraint
Sample Code for Disabling a Constraint
<source lang="sql">
ALTER TABLE MyTable NOCHECK CONSTRAINT FK1_MyTable
</source>
<source lang="sql">
ALTER TABLE MyTable NOCHECK CONSTRAINT FK1_MyTable
</source>