O'Reilly logo
  • Morgan Helms thinks this is interesting:

A candidate key is a key defined on one or more attributes that prevents more than one occurrence of the same tuple (row in SQL) in a relation. A predicate based on a candidate key can uniquely identify a row (such as an employee). You can define multiple candidate keys in a relation


Cover of Microsoft® SQL Server® 2012 T-SQL Fundamentals


A candidate key provides entity integrity