Delete from multiple related tables on one id?

Question

I have three tables.

Table 1 (table1_id, table1_name)
Table 2 (table2_id, table1_id, table2_name)
Table 3 (table3_id, table2_id, table3_name)

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?

Which DBMS are you using? Postgres? Oracle? – Jul 15 '15 at 12:10 — , Jul 15 '15 at 12:10

score 2 · Accepted Answer · edited May 23 '17 at 12:14

2

If you are using sql server then you can go for option "Cascade Delete". Use this option for Table1 and Table2 it should work.

How to use Cascade Delete

edited May 23 '17 at 12:14

Community

1
1

answered Jul 15 '15 at 11:40

Sagar Shirke

648
9
32

1

This is available in most databases. – Gordon Linoff Jul 15 '15 at 11:43
OK..Thanks Gordon for sharing information..I was not sure about it. – Sagar Shirke Jul 15 '15 at 11:45

Delete from multiple related tables on one id?

1 Answers1