foreign key

foreign key definition - computer

In relational databases, it is a field in one table that is indexed in another. Foreign keys provide the building blocks for relating tables. For example, in a customer order table, the salesperson field might contain an employee number. That field would be a foreign key in the table, because the employee table would be indexed on employee number. See entity relationship model.


ERWIN.GIF


Foreign Keys

Note the "FK" indications in this Erwin entity relationship modeling program. Every foreign key is a field in one table that is indexed in another. (Example courtesy of Logic Works, Inc.)






Computer Desktop Encyclopedia THIS DEFINITION IS FOR PERSONAL USE ONLY
All other reproduction is strictly prohibited without permission from the publisher.
Copyright © 1981-2009 by Computer Language Company Inc. All rights reserved.

Comments
Improve this definition.
Do you have more to add? Share your linguistic knowledge or observation.
/Register to save your comments.