CASCADE

Also written: ON DELETE CASCADE

An ON DELETE option that deletes the linked rows too. Deleting an order also deletes its order_items. Added to DROP, it also drops things that depend on the object.