MySQL Forums
Forum List  »  Newbie

Re: Finding out all Foreign Key
Posted by: Bob Field
Date: September 07, 2006 10:18PM

In 5.0, the table_constraints system view in the information_schema database lists foreign keys. Using judiciously named foreign keys, you can easily produce such a list.



Edited 1 time(s). Last edit at 09/07/2006 10:19PM by Bob Field.

Options: ReplyQuote


Subject
Written By
Posted
September 07, 2006 10:01PM
Re: Finding out all Foreign Key
September 07, 2006 10:18PM


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.