foreign key

Computing Dictionary

foreign key definition

database
A column in a database table containing values that are also found in some primary key column (of a different table). By extension, any reference to entities of a different type.
Some RDBMSs allow a column to be explicitly labelled as a foreign key and only allow values to be inserted if they already exist in the relevant primary key column.
[Is it still a foreign key if the primary key is in a different column in the __same__ table?]
(2005-01-14)
The Free On-line Dictionary of Computing, © Denis Howe 2010 http://foldoc.org
Cite This Source
Explore Dictionary.com
Next Definition: foreign language
Words Near: foreign key
More from Thesaurus.com
Synonyms and Antonyms for foreign key
More from Reference.com
Search for articles containing foreign key
More from Dictionary.com Translator
Dictionary.com Word FAQs

Dictionary.com presents 366 FAQs, incorporating some of the frequently asked questions from the past with newer queries.

Copyright © 2014 Dictionary.com, LLC. All rights reserved.
  • Please Login or Sign Up to use the Recent Searches feature