- primary key does not allow nulls however unique key does allow.
- primary key does clustered indexing, whereas unique key does non clustered indexing.
- both can be used for constraints.
- multiple unique keys can be defined for a table, but only a single primary key in a table.
No comments:
Post a Comment