Relational Keys


The term key is much abused and misunderstood.

A key of a relation is any combination of columns whose values uniquely identify each tuple (row) in that relation.

A key is not an index and an index is not a key. This is a lingering confusion from non-relational methods.

Relational keys are more formally (and awkwardly) called Candidate Keys.



Copyright © 1996 Applied Information Science International