A database has two tables: ORDERS (parent) and ORDERITEMS (c…
A database has two tables: ORDERS (parent) and ORDERITEMS (child), linked by an ‘order_id’ column (both tables have the same column name). The foreign key constraint includes ON DELETE CASCADE. If a row in the ORDERS table is deleted, what happens to the corresponding rows in the ORDERITEMS table?
Read Details