Post reply

Sysindexes table

  • January 11, 2006 at 7:41 am

    #364640

    In the SQL Server Books Online the sysindexes table column status has the Description - "Internal system-status information". Does anyone know the actual description for the status column? (For example: There is a description for sysdatabases.status.)

  • January 11, 2006 at 8:56 am

    #614090

    To find out some information, look in the master db for sp_helpindex. Stats are used to indicate the following:

    ignore duplicate keys

    unique

    ignore duplicate rows

    hypothetical

    statistics

    primary key

    unique key

    auto create

    stats no recompute

  • January 11, 2006 at 9:26 am

    #614097

    I found the answer:

    sysindex.status:

    2 = unique index,

    16 = clustered index,

    64 = index allows duplicate rows,

    2048 = the index is used to enforce the Primary Key constraint,

    4096 = the index is used to enforce the Unique constraint.

    Thanks to everyone.

  • January 11, 2006 at 2:46 pm

    #614196

    yes those values are correct if you perform a bitwise and comparison on the value and a nonzero value is returned. This must be performed for each status value, since an index can be: unique and clustered and indicate a primary key and etc...

Viewing 4 posts - 1 through 3 (of 3 total)

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