What is a surrogate key, and when should you use one?

New Tables

A surrogate key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables. Surrogate keys are usually numeric, they are often automatically generated by the DBMS, they are free of semantic content (they have no special meaning), and they are usually hidden from the end users.

Bijay Satyal
Oct 23, 2021
More related questions

Questions Bank

View all Questions