DictionaryAI

candidate key

Short definition from Wiktionary

Noun

  1. In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table, having a unique value or set of values in each row. One of the candidate keys (abbreviated CKs) will be the primary key.

We haven’t written up candidate key yet: Simple and Standard meanings, examples and a quiz.