What is the difference between primary key and unique constraints?

Last updated 4 years, 11 months ago | 985 views 75     5

Tags:- SQL MySQL

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