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 vote291 views1 answer
Selecting Data in SQL - Select Data
SQL
13 votes301 views2 answers
Get tables in database sql
SQL
1 vote289 views2 answers
Mysql show views
SQL
0 vote286 views1 answer
Postgresql default value boolean
SQL
0 vote314 views1 answer
Modifier une valeur sql
SQL
2 votes286 views3 answers
How to pass password mysql command line
SQL
0 vote270 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
4 votes298 views3 answers
Rename table column postgresql
SQL
1 vote290 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote334 views1 answer
Db.Database.SqlQuery
SQL