Candidate key

From Oracle FAQ
Jump to: navigation, search

A candidate key is a key that uniquely identifies rows in a table. Any of the identified candidate keys can be used as the table's primary key. Candidate keys that are not part of the primary key are called alternate keys.

One can describe a candidate key as a super key that contains only the minimum number of columns necessary to determine uniqueness.

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #