Difference between revisions of "ForeignKey"

From Dabo Wiki
Jump to: navigation, search
(Created page with "In relational database design, a record that is related to a record in another table stores the PrimaryKey of that related record in a ForeignKey field. When the tables ar...")
 
(No difference)

Latest revision as of 15:20, 11 May 2020

In relational database design, a record that is related to a record in another table stores the PrimaryKey of that related record in a ForeignKey field. When the tables are joined in a SQL query, this is the field in the child table that is joined to the parent table.

For more info, see Wikipedia Foreign Key