Do you have a question? Post it now! No Registration Necessary. Now with pictures!
July 10, 2006, 9:32 pm
rate this thread
Is there a way to look for all the child tables of a table in MySQL
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!
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum