469,623 Members | 980 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Child Tables MySQL 4.1


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!

Jul 10 '06 #1
0 1644

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Harlan Messinger | last post: by
reply views Thread by lawpoop | last post: by
5 posts views Thread by PAUL | last post: by
3 posts views Thread by reachsamdurai | last post: by
8 posts views Thread by Rick | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.