RE: Find foreign key for a table

2006-11-14 Thread Tim Lucia
ember 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 - He

Re: Find foreign key for a table

2006-11-14 Thread Peter Brawley
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

RE: Find foreign key for a table

2006-11-14 Thread Waldemar Jankowski
006 10:16 AM To: MySQL List Subject: Find foreign key for a table 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

RE: Find foreign key for a table

2006-11-14 Thread Clyde Lewis
t wrote: show create table ? -Original Message- From: Clyde Lewis [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED] Sent: Tue 11/14/2006 10:16 AM To: MySQL List Subject: Find foreign key for a table Hello, How can I find the foreign keys for a table? I would like to be able to fin

Find foreign key for a table

2006-11-14 Thread Clyde Lewis
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 wan