
What is the difference between primary key and unique constraints?
Last updated 5 years, 8 months ago | 1599 views 75 5

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