Listing foreign keys

[Mathieu Dumoulin]

Hi, this may have been asked before but i couldn't find the right keywords for it on the search or in google.

I'd like a way to list the different foreign keys existing in all tables of a database. I'm building an ORM and the previous one relied on having specific field/table names to issue a map between the php objects but this caused me problems from time to time so i'd like to be able to list the FK's of a table to create the relationships in my ORM.

Thanks

PS: Someone mentionned SHOW TABLE STATUS on the net, but all there is in there is a comments column i'd have to parse... it's a pretty weak method in my opinion.