What is a foreign key?

A foreign key is a field (or set of fields) in one table that refers to a key in another table, linking related records. For example, an Orders table might contain a CustomerID that matches a customer’s ID in the Customers table. Choice C describes a primary key, which uniquely identifies a record within its own table.

AI-written and checked against the verified answer.