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:[EMAIL PROTECTED] 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
