Below are the tables of relevance:
Table_B B_ID(PK) Name A_Id 1 A 1 2 B 1 Table_C C_ID B_Id(FK) 1 1 2 1
Now I want to delete rows from
Table_B and from its child table
Below is the query I am firing:
delete from Table_B where A_Id = 1
I want to delete all rows from its child too. Is it possible with a Trigger? I have made a Trigger on
Table_B, but it deletes only one row; so I have to run a loop.