Status & 1 = 1 in sysconstraints

Is there an official guide how to deciper the status in sysconstraints -one example being if Status &  1 = 1

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
anushahannaAuthor Commented:
&7 works.!
0
 
Tim HumphriesDirectorCommented:
This link http://msdn.microsoft.com/en-us/library/ms190365.aspx gives the following information:


Pseudo-bit-mask indicating the status. Possible values include the following:

1 = PRIMARY KEY constraint

2 = UNIQUE KEY constraint

3 = FOREIGN KEY constraint

4 = CHECK constraint

5 = DEFAULT constraint

16 = Column-level constraint

32 = Table-level constraint
0
 
Tim HumphriesDirectorCommented:
p.s. so the test you posted is checking whether the column is a primary key
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
anushahannaAuthor Commented:
TimHumphries,
>>so the test you posted is checking whether the column is a primary key

I find that inconsistant. For example, all the rows in the result set have Status &  1 = 1, even for the AuditUserID column.
0
 
mdagisCommented:
You can have more than 1 columns per table as primary key.
0
 
anushahannaAuthor Commented:
>>Pseudo-bit-mask indicating the status

I ran the following:
select
    con.status & 1 'and 1',
    con.status & 2 'and 2',
    con.status & 3 'and 3',
    con.status & 4 'and 4',
    con.status & 5 'and 5',
    con.status & 16 'and 16',
    con.status & 32 'and 32'
from sysconstraints con
    join syscolumns c on con.colid = c.colid and c.id = con.id and get the following- so you can see that Status &  1 is not helpful in pinpointing the PK.
and 1	and 2	and 3	and 4	and 5	and 16	and 32
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
0	0	0	4	4	16	0
0	0	0	4	4	16	0
0	0	0	4	4	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	2	3	0	1	16	0
1	0	1	4	5	16	0
1	0	1	4	5	16	0

Open in new window

0
 
anushahannaAuthor Commented:
>>You can have more than 1 columns per table as primary key.
agreed; but I do not have the logic right, as per the previous post you would see that it is indicating all columns are PK, which is not true.
0
 
Tim HumphriesDirectorCommented:
Yes, I guess '1' on its own is not purely PK. If Status & 3 = 1 then PK, if = 3 then FK. It does say it's a pseudo bit mask - looks as though it cannot be used strictly as one and you'll have to interpret the values in status using the values defined, rather than using & to test specific bits.
0
 
anushahannaAuthor Commented:
good thought there.
Status &  3 = 1 still comes for non-PK columns.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.