Surrogate key

From Oracle FAQ
Jump to: navigation, search

A surrogate key (also known as artificial or identity key) is a system generated key with no business value. Usually implemented with database generated sequences.

Some examples:

  • Truck number
  • Airport ID
  • Sale ID

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #