INDEXES

• Subu

  Say Hey Kid

  Points: 680

  More actions

  September 19, 2007 at 5:39 am

  #118660

  HI Everybody,

  Today i had created some table, indexes

  How can i cheack which index i had created eg; cluster index or nonclusterindex

  How can i cheack in Query analaiser

  on which command i can see that contents

  plx help me

  Thsx

• Fracn

  Old Hand

  Points: 389

  More actions

  September 19, 2007 at 6:13 am

  #734541

  Hi!

  You can use this stored procedure

  sp_helpindex [tablename]

  which gives you the index name,the index description and the index keys.