Services
/
Profiles
/
Contact
View MS SQL Index Information
SQL Server transact SQL statement to fetch information on table indexes.
select o.name, ind.name, ind.index_id, ic.index_column_id, col.name, ind.*, ic.*, col.* from sys.indexes ind inner join sys.index_columns ic on ind.object_id = ic.object_id and ind.index_id = ic.index_id inner join sys.columns col on ic.object_id = col.object_id and ic.column_id = col.column_id inner join sys.tables t on ind.object_id = t.object_id inner join sysobjects o on t.object_id = o.id where ind.is_primary_key = 0 and ind.is_unique = 0 and ind.is_unique_constraint = 0 and t.is_ms_shipped = 0 order by t.name, ind.name, ind.index_id, ic.index_column_id
