Check index sql server

create procedure _ListIndexes(@tableName nvarchar(200))
as
begin
/*
exec _ListIndexes '<YOUR TABLE NAME>'
*/
SELECT DB_NAME(DB_ID()) as DBName,SCH.name + '.' + TBL.name AS TableName,IDX.name as IndexName, IDX.type_desc AS IndexType,COL.Name as ColumnName,IC.*
    FROM sys.tables AS TBL 
         INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id 
         INNER JOIN sys.indexes AS IDX ON TBL.object_id = IDX.object_id 
         INNER JOIN sys.index_columns IC ON  IDX.object_id = IC.object_id and IDX.index_id = IC.index_id 
         INNER JOIN sys.columns COL ON ic.object_id = COL.object_id and IC.column_id = COL.column_id 
        where TBL.name = @tableName
    ORDER BY TableName,IDX.name

end

Source: stackoverflow.com

Similar codes

0 vote185 views1 answer
Copy value from one column to another postgres
SQL
1 vote183 views2 answers
Install mysqldump ubuntu
SQL
0 vote258 views1 answer
How to check event scheduler status mysql
SQL
27 votes226 views5 answers
Mysql set password for user
SQL
10 votes188 views3 answers
Insert into auto increment mysql
SQL
0 vote252 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote208 views1 answer
How to get data from 2 database
SQL
1 vote296 views1 answer
Python clean sql string
SQL
1 vote180 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote135 views1 answer
Oracle sql developer script output limit
SQL