General discussion


SQL Server

By jabasd ·
Difference Between Primary Key and Unique Constraints. y Primary key is using offen and y not Unique constraint.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Two differences

by Tony Hopkinson In reply to SQL Server

Primary Keys are clustered Unique are not.

Primary keys can only be put on NOT NULL columns, you can build a Unique key on a nullable column, but bear in mind because it's unique, you can only have one null in the table at a time, so that particular facility is of limited value.

Related Discussions

Related Forums