Skip to content

Instantly share code, notes, and snippets.

@m4tt1mus

m4tt1mus/ToggleConstraints.sql

Created August 15, 2014 21:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save m4tt1mus/852271687d46232296ce to your computer and use it in GitHub Desktop.
Save m4tt1mus/852271687d46232296ce to your computer and use it in GitHub Desktop.
Download ZIP
Toggle constraints
Raw
ToggleConstraints.sql
-- turn off constraints on db
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
-- turn on constraints on db
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment