How to delete all dependent rows

Vote count:

0

I have a table A which has primary key column a and it is forigen key to B table(Table B has primary key b and column a).Table B has also a primary key b which forigen key to C table and so on.

Now if I want to delete a row from Table A then it wont allow me because its dependent table B and table B is dependent on Table C.So I have to delete a row from C first then B and at last A manually

So can anybody please tell me if there is any way to delete directly without going to each table and checking if it has any dependencies or not and then deleting

asked 1 min ago

SpringLearner

7,938

How to delete all dependent rows