Differences between a primary key and a unique key

Question

What are the differences between a primary key and a unique key?

Answer 1

Both primary and unique keys are defined to make sure unique row.

• Primary key makes a clustered index upon the column by default.

• Unique makes a non-clustered index by default.

• Primary key does not permit NULLs, but unique key permits one NULL only.