Index List for tables

SELECT
Object_Name(SI.ID) AS TableName
, SI.Name AS IndexName
FROM
sysindexes AS SI
WHERE
SI.IndID BETWEEN 1 AND 254
AND indexproperty(SI.ID, SI.Name, 'IsHypothetical') = 0
AND indexproperty(SI.ID, SI.Name, 'IsStatistics') = 0
AND indexproperty(SI.ID, SI.Name, 'IsAutoStatistics') = 0
----- For a particular Table
-- AND Object_Name(SI.ID) = 'TableName'
ORDER BY
TableName
, IndexName

----- Get list of Indexes and column detail
EXEC sp_helpindex TableName