Ties two tables together by storing, in a column of one, the primary key values of matching rows in the other; referential integrity can then be enforced by the database.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Foreign key in context, with comparison tables and the common traps.
Terms in this definition
- Primary key
Uniquely identifies every row in a relational table, using one column or several together. A foreign key in another table holds this value to reference the row.
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.
- Referential integrity
A guarantee, upheld by foreign key constraints in a relational database management system, that no foreign key refers to a missing row; any change that would break such a link is refused.
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA.