Foreign Key

Columns whose values must match a referenced unique or primary key, subject to NULL rules.

What is Foreign Key in a relational database?

Foreign Key — Columns whose values must match a referenced unique or primary key, subject to NULL rules.

CREATE TABLE purchase_order (
    order_id INTEGER PRIMARY KEY,
    customer_id INTEGER REFERENCES customer (customer_id)
);

Level: Novice · More Database terms at this level

Updated