• 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.