Auto-delete child rows on parent delete
SQL
Medium
7 views
Problem Description
In Customers(customer_id) and Orders(order_id, customer_id), make it so when a customer is deleted, all their orders are deleted too.
Output Format
DDL statement(s)
Constraints
Assume tables exist
Official Solution
ALTER TABLE Orders ADD CONSTRAINT fk_orders_customers FOREIGN KEY (customer_id) REFERENCES Customers(customer_id) ON DELETE CASCADE;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!