What is the meaning of hbcolid field?

• keithy_sunny

  Mr or Mrs. 500

  Points: 566

  More actions

  October 23, 2015 at 11:47 pm

  #301680

  Hi,

  I just connect to SQL Server and invoke the following command:

  Select * from sys.sysrscols

  The result table contain a field ‘hbcolid’, which seem to be identical to ‘rscolid’. I think rscolid is surely for rowset column id. Then what is the meaning and usage of hbcolid? Is there any document on this?

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 24, 2015 at 3:52 am

  #1835339

  The hidden system tables are not documented in any way, and you probably shouldn't be using them. Use the documented system views and DMVs instead.

  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