Iver's web place

 
DECLARE _at_IndexInfo  TABLE (index_name         varchar(250)
                          ,index_description  varchar(250)
                          ,index_keys         varchar(250)
                          )
 
INSERT INTO _at_IndexInfo
exec sp_msforeachtable 'sp_helpindex ''?'''
SELECT index_name, FROM _at_IndexInfo
 
 

 
sp_helpindex 'Production.Product'
 

 
SELECT  s.name AS [Schema], t.name AS TableName,
    ind.name, ind.index_id, ic.index_column_id, col.name,
    ind.*, ic.*, col.*
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 col
                ON ic.object_id = col.object_id AND ic.column_id = col.column_id
        INNER JOIN      sys.TABLES t
                ON ind.object_id = t.object_id
        INNER JOIN sys.schemas s
                ON t.schema_id = s.schema_id
WHERE
    ind.is_primary_key = 0
    AND ind.is_unique = 0
    AND ind.is_unique_constraint = 0
    AND t.is_ms_shipped = 0
        AND t.name LIKE '<Table_Name>'
        AND s.name LIKE '<Schema_Name>'
ORDER BY
    t.name, ind.name, ind.index_id, ic.index_column_id