RDBMS Fundamentals

Candidate Key

English

Overview

A column (or set of columns) that can uniquely identify a row and could serve as the primary key.

Details

A set of one or more columns satisfying uniqueness and minimality, making it eligible to serve as the primary key. The ones not ultimately chosen are called alternate keys.

More Database terms