Query to find the columns on which index is existent

select c.name as “table_name” ,b.name as “column_name”,d.name as “index Name” from sys.index_columns a, sys.columns b , sys.objects c , sys.indexes d
where a.object_id=b.object_id and a.column_id=b.column_id and c.object_id=b.object_id
and d.object_id=c.object_id
order by c.name

Advertisements