What is diff between unique and primary? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

What is diff between unique and primary?

6th Aug 2016, 8:58 PM
Mohamed Fawzy
Mohamed Fawzy - avatar
3 Answers
+ 5
Unique doesn't allows duplicate values but it allows null values. Primary key is used to uniquely identify the records in the table. and it doesn't allows both duplicate and null values.
8th Aug 2016, 9:02 AM
k JayaprakashReddy
k JayaprakashReddy - avatar
0
Primary key also allows to access data faster
16th Aug 2016, 9:24 PM
Haaris Ali
Haaris Ali - avatar
0
both unique and primary key does not allow duplicate values . but unique key allows null value but primary key does not allow null value and also primary key values are arranged in ascending order by default but unique key values are not arranged in ascending order.
11th Sep 2016, 6:14 PM
Shreyansh Dwivedi
Shreyansh Dwivedi - avatar