Wednesday 28 August 2013

What is a difference between unique + not null and primary key?

Unique and not null is a combination of two constraints that can be present any number of times in a table and can’t be a referential key to any column of another table.
Primary key is a single constraint that can be only once for a table & can be referential key to a column of another table becoming referential integrity.

No comments:

Post a Comment