Difference between Primary key and Unique key?
Answers (2)Add Answer
The primary key and unique key both provide uniqueness to the column.
The main difference between them is the primary key can identify each record in the table and can not accept NULL value, and the unique key prevents duplicate entries in a column except for a NULL value, but only one NULL is allowed per column.
A table cannot have more than one primary key column but a table can have more than one unique key column.