Networks

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Locked

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