Child Tables MySQL 4.1
am 10.07.2006 23:32:57 von AndyHello
Is there a way to look for all the child tables of a table in MySQL
4.1?
I know for the latest version of MySQL you can use
information_schema.table_constraints to look the same. Is there
something similar there for MySQL 4.1?
Right now, I'm running SHOW CREATE TABLE `$table` for all tables, and
then seeing if they have the table I'm looking for any foreign key
relationship. This dosnt seem to be the most effective way of doing it.
Any help will be greatly appreciated. Thanks!