In MySQL, I'm working with a database that has integrity constraints on foreign keys (nothing overly special here).
Is there a method to somehow visualize the effects of a cascading delete or update?
I would like to somehow see all records that will be effected, the whole chain of it, across all involved tables, preferably (but not a hard requirement at all) before they happen. Is this possible?
I'm trying to estimate the impact of cascading deletes/updates, seeing the result would greatly speed up my understanding.