anushahanna
asked on
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
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
p.s. so the test you posted is checking whether the column is a primary key
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
>>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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>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.
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
ASKER
>>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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
good thought there.
Status & 3 = 1 still comes for non-PK columns.
Status & 3 = 1 still comes for non-PK columns.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.