sys.indexes, sys.index_columns, sys.columns and sys.table
use dbdocs; --Replace this with your DBNAME select t.name table_name, i.name index_name, c.name column_name, ic.index_column_id, i.type_desc, i.is_primary_key, i.is_unique from sys.indexes i inner join sys.index_columns ic on i.object_id = ic.object_id and i.index_id = ic.index_id inner join sys.columns c on ic.object_id = c.object_id and ic.column_id = c.column_id inner join sys.tables t on i.object_id = t.object_id order by t.name, i.name, ic.index_column_id;
Column | Description -------------------------------- | -------------------------------------------- table_name | Table name with the index. index_name | Index name. column_name | Column name within the index. index_column_id | Order of the columns within the index. type_desc | Index type. is_primary_key | Generated from a PRIMARY KEY (1=primary key). is_unique | Index is unique (0=non unique, 1=unique).