What is a FOREIGN KEY?

Question

Accepted Answer

A FOREIGN KEY enforces referential integrity - you cannot insert a value that has no matching row in the parent table. For example, an orders.customer_id foreign key means you cannot create an order for a customer_id that does not exist in the customers table. Foreign key columns can hold NULLs (meaning 'no relationship'), and they do not need to be unique.