Skip to content

Instantly share code, notes, and snippets.

@tompazourek

tompazourek/Temporarily disable constraints.sql

Created September 1, 2015 13:44
Show Gist options
  • Save tompazourek/b929933dd94a73bbd5f2 to your computer and use it in GitHub Desktop.
Save tompazourek/b929933dd94a73bbd5f2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Temporarily disable constraints.sql
-- 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment