Listing 1: Traditional Query to List Indexes and Columns

SELECT table_name = OBJECT_NAME(i.[object_id]), ic.index_id, index_name = i.name,
  c.column_id, column_name = c.name, ic.key_ordinal 
FROM sys.index_columns ic 
JOIN sys.columns c ON ic.[object_id] = c.[object_id] 
  AND ic.column_id = c.column_id
JOIN sys.indexes i ON i.[object_id] = ic.[object_id] 
  AND i.index_id = ic.index_id
WHERE c.[object_id] = OBJECT_ID('SalesLT.Address')
ORDER BY i.index_id, ic.key_ordinal