identifying foreign keys

[Michael Conlen]

I'm working on a system that will allow me to perform operations on a 
table using a web form, and I would like to know if a table has a 
foreign key, however I don't seem to see this information listed in any 
of the show commands output (or describe). Any idea how I could identify 
what colums are foreign keys and what they reference without having to 
tell the code? I use 'describe table' to get most of the information out 
I need.

Oh yes, MySQL 4.0.12 on FreeBSD using INNODB tables.

Thanks much.

--
Michael Conlen


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]