SQL Server - Display Indexes With Their Columns & Included Columns
Display SQL Server Index Details – Type, Key Columns, Included Columns
Have you ever wanted a query that would give you a list of all the indexes that exist in your database along with details of the index type and all the columns that are a part of the index key and all included columns?
Well have a look at this query. It might help: