Find all the child tables - based on primary key - foreign key relatio

[LalanKG]

Hi,
Can some one help me with this query?

my requirement is.. I need to list all the child tables associated with a parent table.
ie for eg : table EMP has one field emp_id as PK.
This PK is referenced by say tables WORKER,MANAGER etc.

The result of the query should be WORKER,MANAGER etc...
ie the associated tables..

Lalan

 

[ericbrunson]

The only way to do it would be to examine the output of "show create table" for all your tables. Mysql versions below 5 do not maintain a data dictionary (Codd's rule 3 is it?).