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);
- The row is stored as an orphan
- The insert fails a FK check
customer_idis set to NULL- 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 ▸