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.

1 total post (Page 1 of 1)  
| 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.

Back to Networks Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums