Clyde,

>How can I find the foreign keys for a table?

At http://www.artfulsoftware.com/mysql-queries.php in the left pane click on DDL then on 'Find parent tables'. HTH.

PB

-----

Hello,

How can I find the foreign keys for a table? I would like to be able
to find, for any table, the columns that are foreign keys and what
tables/columns the foreign keys are related to. Basically what I am
trying to do is this. My developers want to allow logical deletes of
data. I don't want them to be able to logically delete a record that
has related records.

Thanks in advance