Category: TRICKS

Get Indexes in SQL Server

Get Indexes in SQL Server

Use below query to get Indexes in the SQL Server SELECT ind.name ,ind.index_id ,ic.index_column_id ,col.name ,t.name 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...