doubt on indexes

• nageswara.dhaveji

  SSChasing Mays

  Points: 601

  More actions

  November 14, 2008 at 5:22 am

  #94095

  Hi everybody,

  

  Please tell me how to list out the indexes in a database, on which table and which column the index is created.

  Thanks

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  November 14, 2008 at 5:34 am

  #898496

  nageswara.dhaveji (11/14/2008)

  ---

  Hi everybody,

  

  Please tell me how to list out the indexes in a database, on which table and which column the index is created.

  Thanks

  to check the table Employee, use this

  sp_help employee

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• AnzioBake

  SSCarpal Tunnel

  Points: 4135

  More actions

  November 14, 2008 at 5:53 am

  #898503

  I think You are looking for something like:

  select

  Object_Name( Object_Id)

  , *

  from sys.indexes

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 14, 2008 at 9:11 am

  #898694

  sp_helpindex for indexes on a table, or use sys.indexes and sys.index_columns to get all of the indexes in the DB

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• nageswara.dhaveji

  SSChasing Mays

  Points: 601

  More actions

  November 16, 2008 at 11:17 pm

  #899174

  Thanks to all. That servers my requirement.

  Thanks once again :Whistling: :satisfied:

  Nagesh