Visualize the effects of a cascading delete or update?
3
votes
0
answers
176
views
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?
**Update**
I'm trying to estimate the impact of cascading deletes/updates, seeing the result would greatly speed up my understanding.
I'm trying to estimate the impact of cascading deletes/updates, seeing the result would greatly speed up my understanding.
Asked by Jacco
(131 rep)
Mar 17, 2016, 08:30 PM
Last activity: Jul 23, 2023, 09:40 PM
Last activity: Jul 23, 2023, 09:40 PM