The following example shows how to setup and cascade works when deleting record from parent table. 1) Shows how DELETE cascade works -- Parent table CREATE TABLE supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50), contact_name varchar2(50), CONSTRAINT supplier_pk PRIMARY KEY (supplier_id) ); -- children table with foreign key CREATE TABLE products ( product_id numeric(10) … Continue reading How does cascade work in cases of delete/update for foreign key? →