Skip to content

Instantly share code, notes, and snippets.

@koffisani

koffisani/enable-constraint-sql-server.sql

Created December 26, 2016 11:17
Show Gist options
  • Save koffisani/556f2cdfe91f2853d47ccb0dd5d12d9e to your computer and use it in GitHub Desktop.
Save koffisani/556f2cdfe91f2853d47ccb0dd5d12d9e to your computer and use it in GitHub Desktop.
Download ZIP
Enable Constraints in SQL Server
Raw
enable-constraint-sql-server.sql
USE <nom_database>;
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