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
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.5/533 - Release Date: 11/13/2006

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.