surrogate key

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



surrogate key (plural surrogate keys)

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.