$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #32

With foreign keys enforced, what happens?

CREATE TABLE orders (
  id INT PRIMARY KEY,
  customer_id INT REFERENCES customers(id)
);
-- no customer has id 999
INSERT INTO orders VALUES (1, 999);
  1. The row is stored as an orphan
  2. The insert fails a FK check
  3. customer_id is set to NULL
  4. A customer 999 is auto-created
A foreign key only accepts values that exist in the referenced column, so the insert is rejected.
Play SQL & Databases ▸