I saw thisone in MSDN magazine.i wanted to Temporary disable Foreignkeys,Can i do using following code.. Not needed to delete but temporary disable because i wanted to enable again
ALTER TABLE Orders NOCHECK CONSTRAINT FK_Orders_Customers
-- Disable the constraint.
-- Reenable the constraint.
ALTER TABLE Orders WITH CHECK CHECK CONSTRAINT FK_Orders_Customers
1.4m articles
1.4m replys
5 comments
57.0k users