Skip to content

Instantly share code, notes, and snippets.

@FeniXb3

FeniXb3/Disable and re-enable all constraints on database.sql

Last active December 26, 2015 08:29
Show Gist options
  • Save FeniXb3/7122905 to your computer and use it in GitHub Desktop.
Save FeniXb3/7122905 to your computer and use it in GitHub Desktop.
Download ZIP
Disable and re-enable all constraints on database in T-SQL. Reference - http://stackoverflow.com/a/161410/1816426
Raw
Disable and re-enable all constraints on database.sql
-- disable all constraints
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
-- enable all constraints - the print is optional
exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment