I have three tables.
I want to delete all the information where table1_id = 33
. How I also delete all table2 rows that have table1_id = 33
and also all table3 rows that have table2_id whose rows in Table 2 have table1_id = 33
? What is the nicest and proper way to do that?
If you are using sql server then you can go for option "Cascade Delete". Use this option for Table1 and Table2 it should work.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments