Difference Between Primary Key And Unique
Primary Key | Unique |
---|---|
A primary key is a constraint that ensures that a field or column of a sql table does not hold duplicate or null values | Unique is a constraint that a field does not have duplicates but allows null values. |
There can be only one primary key in a sql table | A Unique constraint can be applied on more than one field. |