Re: Show Which Tables Reference A Table?

[eric M]

I will suggest you look up for all constraints in the customer table, and with that I am sure you can know which table is referencing a column in the customer table.

You can achieve that by executing this command line:

Select from * information_schema.table_constraints where table_name='customer';

if it doesn't provide all what you want, then execute it without specifing the table. i.e (Select from * information_schema.table_constraints).
This will list all the constraints in your DB and the tables being referenced. I hope this helps you.

cheers,