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
Showing posts with label Disable and Enable Foreign key references in Sql Server 2008. Show all posts
Showing posts with label Disable and Enable Foreign key references in Sql Server 2008. Show all posts
6 September 2011
Subscribe to:
Posts (Atom)