How to find table dependencies in mysql

Question

I created a table which contains both primary as well as foreign keys. Now i wants to know what are the tables which refers my table element as foreign key.

For example, student is a table which contains id (primary key), name element. And standard is an another table which contains class_id (primary key), and stud_id (Foreign key refers student table id field). When i give student table and id field as input, it returns standard table as output. Please suggest me how can i achieve this???

Answer 1

Well here is the link of solution of your problem.

How do I see all foreign keys to a table or column?

mysql innodb: describe table does not show columns references, what does show them?

check it.