Introspecting foreign keys in MySQL

[krillzip]

Hi!

For the moment I'm working on a php script that is introspecting MySQL
databases. The purpose is to document the scheme of a database and
tables automatically. My problem for the moment is to query MySQL for
the foreign keys (InnoDB) in a practical way.

I know I could use : SHOW CREATE TABLE test_db.field_2
but for this I have to parse the outputed SQL.

I want to know if there is a better way to get the foreign key
information

thnx at advance
//krillzip