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