"What component are you suggesting? (view, table, function, procedure)"
Preferably a view, but otherwise a procedure to list "reverse dependencies": a
lost of objects (tables, views, events, functions, procedures, triggers) that
are dependent upon a particular object.
"What will this new component do?"
Provide rows of dependency data:
- object_schema: schema wherein the object resides
- object_name: name of the object
- object_name: type of the object (table, view, etc.)
- dependent_object_schema: schema of the object depending on this object
"Characteristics of the component? (e.g. NO SQL for stored function)"
whatever it takes
"Dependencies for component?"
whatever it takes
"Compatibility with what kind of MySQL version/distribution?"
5.0 and up
"OS specific issues?"
None
"Do you expect this to be a heavyweight operation? Why?"
Yes.
Original issue reported on code.google.com by roland.bouman on 14 Sep 2011 at 8:15
Original issue reported on code.google.com by
roland.boumanon 14 Sep 2011 at 8:15