sys.sysindexes view in sql server 2005

• Pravin Patel-491467

  Say Hey Kid

  Points: 674

  More actions

  October 10, 2007 at 6:30 am

  #178831

  Dear Friends

  In sql server 2005 there is one system view named sys.sysindexes. In this view there is one column keycnt. What this Column indicate. When it's value is 1, when it is 0 and when it is 2.... and more.

  Is this column is useful to Identify the index wether it is system generated or user generated using this column.

  Thank You

  From

  Pravin Patel.

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  October 10, 2007 at 6:47 am

  #740759

  http://msdn2.microsoft.com/en-us/library/ms190283.aspx

  did you not think to check BOL before posting such a question - or even using a search engine ( as I did ) to get this link address ?

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/