Entity keys
Surrogate primary key
A surrogate primary key is created for the purpose of
guaranteeing uniqueness.
Where do surrogate primary key values come from?
- Counter maintained by the database system.
- Error prone, (because programmers
create bugs).
- Unique with extremely high
probability. Can be assigned from applications and by most database
systems.
|