Find dependencies between database objects of MySQL

[Muhammad Intikhab Qaiser]

Hi

I need to find dependency information on procedures and functions, if this function is called from some other procedure or is dependent on a table



What I need is

1.Which views reference table 'A'
2.Which procedures or functions refer to table 'A'
3.What are the tables (or views) being used by view 'X'
4.What are the tables (or views) being used by procedure 'Y'

Thanks