IndexInformation

select
 i.name 'indexes', '',i.type_desc 'indexetype', c.name 'column', '',s.name+'.'+t.name + '.' + c.name 'tables:columns'
from sys.tables t
inner join sys.schemas s on t.schema_id = s.schema_id
inner join sys.indexes i on i.object_id = t.object_id
inner join sys.index_columns ic on ic.object_id = t.object_id
inner join sys.columns c on c.object_id = t.object_id and
        ic.column_id = c.column_id

where i.index_id > 0
 --and i.type in (1, 2) -- clustered & nonclustered only
 --and i.is_primary_key = 0 -- do not include PK indexes
 --and i.is_unique_constraint = 0 -- do not include UQ
 --and i.is_disabled = 0
 --and i.is_hypothetical = 0
 --and ic.key_ordinal > 0
-- and s.name = 'metadata'
order by s.name+'.'+t.name + '.' + c.name,ic.key_ordinal