RESTRICT
A referential action that blocks deleting or changing a parent row while child rows still reference it.
FOREIGN KEY (customer_id) REFERENCES customer(customer_id) ON DELETE RESTRICT
When to use
Choose it when a parent should never disappear while it still has children. The study guide says NO ACTION is similar in MySQL, though in standard SQL the check is deferred to the end of the statement.
See Read 01.