ForeignKey

From Dabo Wiki
Revision as of 15:20, 11 May 2020 by Ed (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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