surrogate key

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

English[edit]

Noun[edit]

surrogate key ‎(plural surrogate keys)

Wikipedia has an article on:
Wikipedia
  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.