Hi,
How do I get the list of all child tables and it's corresponding count of number of rows that got deleted when I use ON DELETE CASCADE option to delete the rows.
An audit of the counts against every table whose rows got deleted.
Table Master 100
Table child1 50
Table child2 5
Table child3 30
How do I get the list of all child tables and it's corresponding count of number of rows that got deleted when I use ON DELETE CASCADE option to delete the rows.
An audit of the counts against every table whose rows got deleted.
Table Master 100
Table child1 50
Table child2 5
Table child3 30