Disable single constraint and ALTER TABLE MyTable CHECK CONSTRAINT

-- Disable single constraint


ALTER TABLE MyTable NOCHECK CONSTRAINT  myconstraint




--Enable single constraint


ALTER TABLE MyTable CHECK CONSTRAINT myconstraint