List:General Discussion« Previous MessageNext Message »
From:Tim Lucia Date:November 14 2006 7:43pm
Subject:RE: Find foreign key for a table
View as plain text  
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 





Thread
Find foreign key for a tableClyde Lewis14 Nov
  • Re: Find foreign key for a tablePeter Brawley14 Nov
    • RE: Find foreign key for a tableTim Lucia14 Nov
RE: Find foreign key for a tableClyde Lewis14 Nov
  • RE: Find foreign key for a tableWaldemar Jankowski14 Nov