Daily Archives: 10/20/2014

How to drop and recreate SQL Server foreign keys?

This entry was posted in Sql Server DEV Sql Server tutorials and tagged drop foreign keys recreate server sql on by .

Scenario You may have been in a scenario where you needed to quickly generate a script to drop and then subsequently re-create all of the foreign keys in a database (or in a specific schema, or matching a specific naming scheme). In some situations you can simply disable and re-enable the constraints, which isn’t all […]