Click here to Skip to main content
15,941,828 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

"Unique Key allows only one NULL Value".
somebody can give some example or justify the statement how its working.
Posted

1 solution

Just think again what you want to achieve.
A (unique) key is used for identifying a record. Any value of the key must exist only one time - how else could it identify a record? When two records have a key value of null, which of the two records is the record identified by null? => better gid rid of the idea of a nullable key, it's confusing only.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900