472,093 Members | 2,520 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,093 software developers and data experts.

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 1675

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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.