Encyclopedia > Foreign key

  Article Content

Foreign key

A value that can be used as the primary key into another table. Since the primary key can be used to look up the information in another table, this information does not need to be included - only the primary key.

For example, a person sending an e-mail need not include the entire text of a book in the e-mail. Instead, they can include the ISBN number of the book, and interested persons can then use the number to get information about the book - or even the book itself. The ISBN is the primary-key of the book, and it is used as a foreign-key in the e-mail.

Note that using a foreign key assumes its existence as a primary key somewhere else. Improper foreign key/primary key relationships are the source of many database problems.



All Wikipedia text is available under the terms of the GNU Free Documentation License

 
  Search Encyclopedia

Search over one million articles, find something about almost anything!
 
 
  
  Featured Article
Jamesport, New York

... land and 8.6 km² (3.3 mi²) of it is water. The total area is 42.82% water. Demographics As of the census of 2000, there are 1,526 people, 605 households, and ...

 
 
 
This page was created in 21.6 ms