Multiple indexes on the same column

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  September 22, 2009 at 11:41 am

  #214684

  Guys,

  Is there anyway from system objects I can find all the columns which have more than one index on it with different names?

  Any suggestions/inputs would be helpful.

  Thanks

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  September 22, 2009 at 11:50 am

  #1057022

  A quick query to get that;

  select object_name(ic.object_id) as object_name, i.name as index_name, COL_NAME(object_id('Sessions'), ic.column_id) as column_name

  from sys.index_columns ic join sys.indexes i

  on ic.index_id = i.index_id

  where ic.object_id = object_id('Sessions')

  I'm sure there are more elegant ways....

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot