>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.
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