How to get index column names of a table from SQL Server

Shiji Pan

8 years ago

select i.name as IndexName, co.[name] as ColumnName from sys.indexes i join sys.objects o on i.object_id = o.object_id join sys.schemas s on s.schema_id = o.schema_id join sys.index_columns ic on ic.object_id = i.object_id and ic.index_id = i.index_id join sys.columns co on co.object_id = i.object_id and co.column_id = ic.column_id where ic.is_included_column = 0 and s.name='my_schema_name' and o.name='my_table_name'