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 vote345 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote324 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote340 views3 answers
How to reset id column in sql server
SQL
3 votes283 views2 answers
Having in mysql
SQL
0 vote274 views1 answer
Update row in sqlite python
SQL
0 vote317 views1 answer
Csv to sqlite python
SQL
0 vote317 views1 answer
Oracle drop type
SQL
2 votes310 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote321 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
1 vote309 views1 answer
Declare table variable
SQL