Thursday, 22 August 2013

Getting the children tables in a mysql database which uses MyIsam engine

Getting the children tables in a mysql database which uses MyIsam engine

I need a sql instruction in mysql that allows me to retrieve the children
tables of a specific table, the peculiarity of this is that the database
uses the MyIsam engine, I think this is possible for I have used SchemaSpy
and the model that this tools produces signals the children tables, I
think this tool uses the key caché of MyISAM as a reference to detect the
children tables.

No comments:

Post a Comment