Super key

A column, or set of columns that uniquely identifies a record within a table.

Candidate key

A superkey that contains only the minimum number of columns necessary for unique identification.

Primary key

The candidate key that is selected to identify records uniquely within the table.

Foreign key

A column, or set of columns, within one table that matches the candidate key of some (possibly the same) table.

Back to Main