Here is a query to find all the indexes on a table.
select r.[name] as table_name, i.[name] as index_name, c.[name] as column_name
FROM sys.index_columns l
inner join sys.tables r on
l.object_id = r.object_id
inner join sys.indexes i on
l.object_id = i.object_id
and l.index_id = i.index_id
inner join sys.columns c on
l.object_id = c.object_id
and l.column_id = c.column_id
where r.[name] = 'table_name_here'
order by r.[name], l.index_id, l.key_ordinal
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.