Unique key and primary key both are represent
unique value in table.
Difference :
- Primary key don't hold any null value but
Unique key can hold null value.
- Unique key can hold only single null
value.
- A table in sql database can have only
single primary key but can have multiple unique key.
- Primary key have clustered index by
default but unique key have non-clustered index by default.