What is the difference between primary key and unique constraints?
Last updated 7 years ago | 2256 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
