I've use MS Visio's "Reverse Engineer" database feature to find the FK
relationships between tables. I'd bet there are other tools which do
something similar, probably even free ones.
Tim
_____
From: Peter Brawley [mailto:peter.brawley@stripped]
Sent: Tuesday, November 14, 2006 2:36 PM
To: Clyde Lewis
Cc: MySQL List
Subject: Re: Find foreign key for a table
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
