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:
“This is not a book. This is libel, slander, defamation of character. This is not a book, in the ordinary sense of the word. No, this is a prolonged insult, a gob of spit in the face of Art, a kick in the pants to God, Man, Destiny, Time, Love, Beauty ... what you will. I am going to sing for you, a little off key perhaps, but I will sing.”
—Henry Miller (1891–1980)
“You cannot go into any field or wood, but it will seem as if every stone had been turned, and the bark on every tree ripped up. But, after all, it is much easier to discover than to see when the cover is off. It has been well said that “the attitude of inspection is prone.” Wisdom does not inspect, but behold.”
—Henry David Thoreau (1817–1862)