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

1 vote91 views6 answers
In sql
SQL
0 vote93 views1 answer
Best sql collation
SQL
6 votes97 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
2 votes89 views1 answer
SQL column name Postgre
SQL
2 votes88 views1 answer
Pandas to sql index
SQL
0 vote88 views1 answer
Mysql default uuid
SQL
0 vote90 views1 answer
Mysql add comment to column
SQL
1 vote93 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote111 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote87 views2 answers
Starting mysql service from mac
SQL