6 September 2011

Disable and Enable Foreign key references in Sql Server 2008

Disable and Enable Foreign key references in Sql Server 2008

-- Disable all table constraints

ALTER TABLE MyTable NOCHECK CONSTRAINT ALL

-- Enable all table constraints

ALTER TABLE MyTable CHECK CONSTRAINT ALL

-- Disable single constraint

ALTER TABLE MyTable NOCHECK CONSTRAINT MyConstraint

-- Enable single constraint

ALTER TABLE MyTable CHECK CONSTRAINT MyConstraint

No comments:

Post a Comment

Comments Welcome