Enable/Disable foreign key constraints in SQL Server
– 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"
Original link here.
VN:F [1.1.6_502]Rating: 0.0/5 (0 votes cast)












