surrogate key

Definition from Wiktionary, the free dictionary
Jump to navigation Jump to search



surrogate key (plural surrogate keys)

English Wikipedia has an article on:
  1. (databases) A unique identifier for an entity or object, not derived from application data.
    We weren't sure which columns in the table would have unique values, so we used a separate surrogate key as the primary key.