Post reply

SysObjects Table - Status column = 32 for PK???

  • February 13, 2004 at 7:26 am

    #160746

    Hi,

    Sql Server 2000 ...

    In the sysobjects systable for a user database, does anybody know what the value 32 represents in the 'status' column for where xtype = 'PK'?? I have 5 entries set to the value 32. The others are set to the value 16?? The ones with 32 do not script???

    Thanks. Jeff

    Many thanks. Jeff

  • February 13, 2004 at 8:40 am

    #494004

    nonclustered, unique, primary key.

  • February 13, 2004 at 9:02 am

    #494013

    Great. Thanks. Any idea why these won't script when using EM "Generate SQL Script"? All the 16's do (I assume they mean clustered PK?)

    Many thanks. Jeff

  • February 13, 2004 at 9:11 am

    #494015

    It is a constraint. Check primary key ... in option tab.

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

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