What's the difference between a primary key and a unique key?

Question

Anonymous User · Answer

Both primary key and unique key enforces uniqueness of the column on which they are 
defined. But by default primary key creates a clustered index on the column, where are 
unique creates a nonclustered index by default. Another major difference is that, primary 
key doesn't allow NULLs, but unique key allows one NULL only.

interview

What's the difference between a primary key and a unique key?

Anonymous User

Can you answer this question?

1 Answers

Liked By