Disable all the constraint in database
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
Enable all the constraint in database
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!
Showing posts with label Disable and Enable all the constraints in a SQL database. Show all posts
Showing posts with label Disable and Enable all the constraints in a SQL database. Show all posts
Thursday, February 19, 2015
Disable and Enable all the constraints in a SQL database
Disable all the constraint in database
Enable all the constraint in database
Subscribe to:
Posts (Atom)