candidate key


candidate key

(database)One of several possible attributes or combinationsof attributes which can be used to uniquely identify a body ofinformation (a "record"). The chosen candidate key iscalled the primary key.

candidate key

One or more columns (fields) in a relational database that can uniquely identify a row in the table. If there are two or more candidate keys, only one is selected as the "primary." See primary key.