Database
28 views
Foreign Key
Quick Definition
Field referencing primary key to establish table relationships
Full Definition
A field in one table that references the primary key of another table establishing a relationship between them.
Examples
referential integrity, JOIN operations, relational design
Related Terms
relational-database
primary-key
normalization
More Database Terms
ORM
Mapping object-oriented code to database tables
SQL
Standard language for managing and querying databases
View
Virtual table defined by a SQL query
Denormalization
Intentionally adding redundancy to improve reads
Cursor
Database object for traversing result sets row by row
Stored Procedure
Precompiled SQL stored in the database for execution