RE: [PHP] Distinguishing foreign keys in a table?

On Sunday, April 20, 2003, at 09:16 PM, Mark Charette wrote:

From: Ken Tozier [mailto:kentozier@attbi.com] Is it possible to determine if a field in a table is a foreign key? I looked at all the mysql_xxx functions but didn't see anything that looked like it would return this type of info. Once a foreign key is established, I would also need to get the table name associate with that key so I could navigate the link. Is that possible?

See http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html and http://www.mysql.com/doc/en/example-Foreign_keys.html to learn how MySQL current handles (and doesn't handle) foreign key constraints.

After reading these links, they seem to imply that there is no built in information a generic PHP routine can extract from a table field to determine if that field is a foreign key or not. It is the programmer's responsibility to know which fields link to which tables and to write custom code for each table type that contains foreign keys. Is that the correct interpretation? Thanks Ken