Explain The Difference Between A Primary Key And A Unique Key?

1.	Explain The Difference Between A Primary Key And A Unique Key?
Answer» Both are defined to ensure unique ROW. Primary key CREATES a CLUSTERED INDEX on the column by default. Unique creates a non-clustered index by default. Primary key doesn't ALLOW NULLs, but unique key allows one NULL only.

Answer»

Discussion