Hi Ralf,
> as far as i know, there is only 1 way to extract the foreign key relations
from a table: "show create table <tablename>".
> Are there any others?
The "comments" column in SHOW TABLE STATUS is supposed
to list the FKs as well. A rather silly way of doing things, IMO,
cause you can't use the "comments" yourself anymore.
Besides, the "comments" field is waaay too short for a larger number
of FKs.
So, as far as I know, SHOW CREATE TABLE is the only way.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
