Skip to content

Glossary: SQL Beyond the Basics

Surrogate key

A made-up ID number with no meaning, such as customer_id, used as a primary key. It is safe because names change and repeat, like the two customers called Wes Ford.

Where the book teaches it

Related terms

Primary key