What is the difference between Primary and Unique key?

Both primary and unique keys enforce uniqueness of the column on which they are defined.

By default a primary key creates a clustered index on the column, where as unique key creates a non-clustered index by default.

Another major difference is that, primary key doesn’t allow NULL’s, but unique key can have one NULL value in it’s list of values.

---

Possibly related posts: (automatically generated)

• Difference between UNIQUE constraint and PRIMARY key
• Indexes in SQL Server
• What are constraints?
• Primary key vs Unique key column