Metraipolis › archive › dc_a400bad95a91

Foreign key — Wikipedia (en)

Source
Wikipedia (en)
Original
https://en.wikipedia.org/wiki/Foreign_key
License (as archived)
CC-BY-SA-4.0
Archived
2026-10-06T17:09:09.463Z
SHA-256 of the archived text
ffc147f363cee08afeeaa025433089a5002523f05aff861dcd273e9bf09a7a7d
Stable URL of this page
https://metraipolis.com/documento/dc_a400bad95a91

How to cite

Foreign key — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Foreign_key (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_a400bad95a91 (Metraipolis archive dc_a400bad95a91, sha256 ffc147f363cee08afeeaa025433089a5002523f05aff861dcd273e9bf09a7a7d)
BibTeX
@misc{dca400bad95a91,
  title = {Foreign key — Wikipedia (en)},
  howpublished = {Wikipedia (en)},
  url = {https://en.wikipedia.org/wiki/Foreign_key},
  note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_a400bad95a91; sha256 ffc147f363cee08afeeaa025433089a5002523f05aff861dcd273e9bf09a7a7d},
  year = {2026}
}

Archived text

Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Foreign_key. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

A foreign key is a set of attributes in a table that refers to the primary key of another table, linking these two tables. In the context of relational databases, a foreign key is subject to an inclusion dependency constraint that the tuples consisting of the foreign key attributes in one relation, R, must also exist in some other (not necessarily distinct) relation, S; furthermore that those attributes must also be a candidate key in S. In other words, a foreign key is a set of attributes that references a candidate key. For example, a table called TEAM may have an attribute, MEMBER_NAME, which is a foreign key referencing a candidate key, PERSON_NAME, in the PERSON table. Since MEMBER_NAME is a foreign key, any value existing as the name of a member in TEAM must also exist as a person's name in the PERSON table; in other words, every member of a TEAM is also a PERSON.

Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; categoria «Databases»).
Fonte: Wikipedia in inglese, voce «Foreign key» — https://en.wikipedia.org/wiki/Foreign_key
Wikidata Q1056760 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q1056760
Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Foreign_key?action=history).
Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza.
Estratto dell'introduzione non modificato nel contenuto; revisione 1270418735, consultata il 2026-10-06T15:35:12.041Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: dd8b421bb345347c3520ae83ad2100c267ac543e01a076b0f711c30e8aaf5267