Skip to main content

Natural Key vs Surrogate Key

Learn Natural Key vs Surrogate Key (Keys, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A natural key is made of real-world data that already identifies the row (email, ISBN, country code). A surrogate key is a meaningless value created by the database (AUTO_INCREMENT, UUID) whose only job is to identify the row.

More lessons in Keys