Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    Disable/Enable all constraints in an MSSQL database

    29-12-2015 17:33:11 MSSQL / Operation 0 Bookmark(s) 191 View(s)

     

    
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

    To re-enable them later:

    
EXEC sp_MSforeachtable @command1="ALTER TABLE ? CHECK CONSTRAINT ALL"