A key field is a field or set of fields (a key is then said to be a composite key) of a database (typically a relational database) table which together form a unique identifier for a database record (a table entry). The aggregate of these fields is usually referred to simply as "the key". Key fields also define searches. Relational databases enforce referential integrity of their tables by matching primary keys with foreign keys. Keys can also be distinguished in technical keys (also known as surrogate keys) and business keys (also known as natural keys or domain keys).
Sometimes programmers embed a list of key values in a non-key character string fields. Many times the values in these fields cannot be guaranteed since no database can enforce the integrity of these values.
Also see primary key and foreign key.
Famous quotes containing the words key and/or field:
“The hypothesis I wish to advance is that ... the language of morality is in ... grave disorder.... What we possess, if this is true, are the fragments of a conceptual scheme, parts of which now lack those contexts from which their significance derived. We possess indeed simulacra of morality, we continue to use many of the key expressions. But we have—very largely if not entirely—lost our comprehension, both theoretical and practical, of morality.”
—Alasdair Chalmers MacIntyre (b. 1929)
“The little toy dog is covered with dust,
But sturdy and stanch he stands;
And the little toy soldier is red with rust,
And the musket moulds in his hands.
Time was when the little toy dog was new,
And the soldier was passing fair;
And that was the time when our Little Boy Blue
Kissed them and put them there.”
—Eugene Field (1850–1895)