Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: sysindexes question

    All,

    Where might I look in SYSINDEXES to determine if an index is
    UNIQUE or NON-UNIQUE?

    I was under the impression that STATUS = 2 means UNIQUE, otherwise it's NOT-UNIQUE. That's not turning out to be the case
    when I actually look and compare to my tables though.

    Any help is greatly appreciated.

    Happy holidays,

    Isaac

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    STATUS is a bit mask =>

    Code:
    WHERE status&2=2

  3. #3
    Join Date
    Dec 2003
    Posts
    44
    That worked perfectly.


    Thanks. I really appreciate the help.

    Happy Holidays,

    Isaac

Posting Permissions

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