Surrogate key

From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽

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

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 #