Often question comes to mind "What's the difference between Primary and Unique Key"

Primary Key:

• Enforce uniqueness
• Never allow NULL value
• By Default create Clustered Index on column

Unique Key:

• Enforce uniqueness
• Allow Null value
• By Default create Non Clustered Index on column

Bandagi!