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 i.name, co.name, ico.* 
from sys.indexes i
inner join sys.index_Columns ico 
   on ico.object_id = i.object_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) = 'Votes'
order by i.object_id 

select *
from sys.columns

view current version

edited may 25

created may 21 rene