Was there a reply to this post? If so, I could have (did) missed it. Can you please resend?
Rgds Paul. Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial to detect which rows in the result of that statement > are your FOREIGN KEYS. They not only indicate which table(s) is/are > this table's parent(s) but also which columns participate in each > relationship. > This technique does not rely on any particular connection library as > the functionality is provided by MySQL itself. Once the > INFORMATION_SCHEMA views are made available as of v5.x+ we will have > an alternative to using the "SHOW" family of statements to extract schema metadata. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
