Skip to content

Instantly share code, notes, and snippets.

@AlbertoMonteiro

AlbertoMonteiro/disableconstraints.sql

Created December 20, 2017 20:25
Show Gist options
  • Save AlbertoMonteiro/e2090ed27f01f83e7fa5f3630b054ebd to your computer and use it in GitHub Desktop.
Save AlbertoMonteiro/e2090ed27f01f83e7fa5f3630b054ebd to your computer and use it in GitHub Desktop.
Download ZIP
Disable constrains SQL Server
Raw
disableconstraints.sql
EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'
EXEC sp_msforeachtable '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