foreign key (foreign keyword)
A foreign key, also called a foreign keyword, in a database table is a key from another table
that refers to (or targets) a specific key, usually the primary key
, in the table being used. A primary key can be targeted by multiple foreign keys from other
tables. But a primary key does not necessarily have to be the target of any foreign keys.
It is possible to change the primary key in a table when the specific needs of the users change.
For example, the people in a town might be uniquely identified according to their driver license
numbers in one application, but in another situation it might be more convenient to identify them
according to their telephone numbers. When the primary key in a table is changed, the set of
associated foreign keys, if there are any, often changes as a result.
This was last updated in September 2005
Email Alerts
Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
Dig Deeper
-
In this second part, expert Mich Talebzadeh looks at how Sybase’s Adaptive Server Enterprise (ASE) in-memory database compares with Oracle TimesTen.
-
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system.
-
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation.
-
People who read this also read...
-
Resources from around the Web
Join the conversationComment
Share
Comments
Results
Contribute to the conversation