MySQL Forums
Forum List  »  Microsoft SQL Server

Identifying Foreign Key constraints
Posted by: Michael Nagel
Date: August 02, 2004 04:50AM

I am trying to change the relations-strukture parallel in Sql Server and MySql...
If i want to drop foreign keys i have to know the KeyId in minimum...

Is there a possibility to query in mysql-DBs (Isam) for
a) foreign key constraints with keyid, source_tableName, dest_tableName
b) foreign key constraints with keyid, source_tableName+columns,
dest_tableName+columns (one entry for each column of reference)

Thanks for help

Michael Nagel

Options: ReplyQuote

Written By
Identifying Foreign Key constraints
August 02, 2004 04:50AM

Sorry, you can't reply to this topic. It has been closed.

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.