0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- sp_helpindex 'Users'
select object_name(i.object_id) [table]
     , i.name
     , i.type_desc
     , co.name [column name]
     --, i.*
     --, ico.* 
from sys.indexes i
inner join sys.index_Columns ico 
   on ico.object_id = i.object_id and ico.index_id = i.index_id
inner join sys.columns co 
   on co.object_id = i.object_id 
   and co.column_id = ico.column_id
where object_name(i.object_id) in ( 'Votes', 'Users' /*, 'PostHistory' */)
order by i.object_id, i.index_id, ico.key_ordinal

select *
from sys.columns

view current version

edited may 25

created may 21 rene