Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013

    Unanswered: What is the meaning of hbcolid field?


    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?


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    First of all, the columns in undocumented view and tables are not guaranteed to exist from one version (or even build) of SQL Server to another so you're on sketchy ground from the outset.

    The short answer is that hbcolid refers to a Heap-or-BTree structure within SQL Server. You are also correct that the rscolid refers to the rowset structure.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts