Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2001
    Posts
    36

    Unanswered: Status Column In sysIndexes Table

    Does anybody have a idea what 'Status' column in Sysindexes table mean ?

    I have a Index on one of my user tables and the status for that index in sysindexs table is '0'. The only problem because of that is when I create a database model thru Erwin (Latest Version) I do not see that particular index.

    Any help is appreaciated.

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I guess your forward engineering...

    Are you sure you selected all the appropriate options

    When you preview it, do you see the index...

    BOL Says status is for internal use...

    SELECT Status, COUNT(*) FROM sysindexes GROUP BY Status


    Gives me:

    Code:
    Status                  
    ----------- ----------- 
    0           117
    2           15
    3           1
    8           6
    18          2
    2050        5
    4098        4
    16402       9
    16403       1
    18450       18
    2097152     21
    2097154     2
    2113554     1
    8388704     38
    10485856    127
    
    (15 row(s) affected)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2001
    Posts
    36
    Thanks for the reply.
    I think we are going to talk to Erwin guys about it. Most probably it is a bug.

    Thanks.

Posting Permissions

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