Post reply

SystemIndexes - Column Ids

  • May 3, 2007 at 12:19 pm

    #119997

    From BOL:

    sysindexes.keys is varbinary(816) List of the column IDs of the columns that make up the index key. All well and good now how does one extract from the horrendous value each colum ID?  How many bits identify a single column.  Does first 16 bits (bits 0 through and including 15) make up the first column id, bits 16 through 31 the 2nd column id? 

    Anyone want to say my presumptions are correct or if not correct tell me the correct format.

    Thanks in advance for anyone's help

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • May 3, 2007 at 12:34 pm

    #704178

    Use the dbo.sysindexkeys table.  You need to join it to the dbo.sysindexes table.

  • May 3, 2007 at 12:34 pm

    #704177

    Use the dbo.sysindexkeys table.  You need to join it to the dbo.sysindexes table.

  • May 3, 2007 at 12:37 pm

    #704179

    Use the dbo.sysindexkeys table.  You need to join it to the dbo.sysindexes table.

  • May 3, 2007 at 12:39 pm

    #704181

    Sorry for the multiple posts, but our internet connection is acting up and out again!

     

  • May 3, 2007 at 1:05 pm

    #704188

    or is it?

  • May 3, 2007 at 1:36 pm

    #704197

    If you only knew.......

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply