![](http://www.studyzone4u.com/assets/image/ads6.jpg)
What is the difference between primary key and unique constraints?
Last updated 5 years, 2 months ago | 1242 views 75 5
![](/media/uploads/2020/06/sz4u-cover-mysql.jpg)
SQL | Difference between primary key and unique constraints
There is only one primary key in a table. It creates the clustered index automatically and it cannot have NULL value
whereas there can be multiple unique constraints in a table. It does not create the clustered index automatically and it can have a NULL value