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]
