A Simple code.. allow you to drop all FK (foreign keys) for a table, you can use @option for generate only the script or execute ( 1 execute, 0 generate).
The Ultimate Index-Less Foreign-Key Finder
Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.
2009-10-15 (first published: 2009-10-01)
1,604 reads