What's the difference between (NOT NULL + UNIQUIE) and Primary key.? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

What's the difference between (NOT NULL + UNIQUIE) and Primary key.?

Is it provided for saving time and space? I means just for ease?

1st Dec 2018, 12:16 AM
Kishor Jena
Kishor Jena - avatar
1 Answer
+ 10
● In unique constraint U can have null values , but in primary key constraint U can't have null values . ● Duplicate values is not allowed in both . ● U can say Primary key cons. = Unique & not-null together .
1st Dec 2018, 5:22 AM
Gaurav Agrawal
Gaurav Agrawal - avatar