 - 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.
| LAST UPDATED: |
04 Apr 2005
|
 |
Read more about foreign key:
|
|
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
 |
 |
| |
RELATED CONTENT
 |
How to create a database link in Oracle
Part of our "How do I do that in Oracle?" series, this tip explains in detail how to create a database link as well as how to troubleshoot db link...
|
|
Most clicked stories of 2007
Our top five most popular learning guides, news stories, tips, blog posts, and expert responses of 2007.
|
|
How do I do that in Oracle?
This series is a collection of tips that explain in detail how to perform specific tasks in Oracle related to database administration.
|
|
|
