/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
-- disable all constraints EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" -- enable all constraints EXEC sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"