What are Candidate Keys?

A candidate key is any set of one table's columns whose combined value is unique throughout that table.

  • In the U.S. each state has a unique code - one candidate key.
  • Each state name is also unique - another candidate key.
  • And so is the order of admission to the union.


    • Copyright © 1996 Applied Information Science International