Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
Return list of commands which can be used for different purposes like recreating foreign keys, disabling or enabling foreign keys. All data about foreign keys are collected so you can modify this script in an easy way.
If you are going to use query output as an input command than be sure that maximum number of characters displayed in column in query window is big enough and your command is not truncated. Spell check is strongly recommended before execution!
understanding go command
Truncate not allowed on table with (disabled) foreign keys?
Generate Script for existing Foreign Keys for any emergency.
Disable foreign constraint