sp_xdetails – index and table info
While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because GUI integration with new SSMS versions were different every time and too much for my poor csharp knowledge. I am a DB guy after all. There are very good news – I wrote a procedure to replace the XDetails Add-in!
This first version shows indexes, columns, foreign keys. Not exactly everything that Addin had, but very close and very usable, using almost the same code to show the info. Feel free to download and enjoy seeing included columns of indexes, script to drop and recreate FKs of child tables, and much more. With time it will have even more features.
Installation instructions are at the top of the script, read them please.