Retrieve Index Information For All Tables - V2

Total article views: 746 | Views in the last 30 days: 4

 Rate this |   Join the discussion |  Briefcase

This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to keep the information for reference purposes, or to recreate a lost index.
***Previous version did not account for multiple fiegroups, this one does, also includes script for recreation of indexes***

Total article views: 746 | Views in the last 30 days: 4