SQL Notification Services Interview Question:

Explain the difference between a primary key and a unique key?

Submitted by: Administrator

► 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.
Submitted by: Administrator