>Hi,
>
>Primary key accepts empty values. Should Primark Key behave like this ?
>Am I wrong somewhere ?
If a primary key is accepting an empty value it's normal. It ensures value would be unique but doesn't guarantee it wouldn't be empty. ie: For an integer PK 0 is a perfectly legal value.
But if a primary key is accepting empty value
s then you've a problem. Keys might not be updating at all.
Not empty is something you should control as well as not null.
Cetin