MySQL Forums
Forum List  »  MySQL Administrator

ForeignKey in 4.1.7 & Admin tool
Posted by: Fred Wohlfert
Date: December 07, 2004 08:38AM

I have installed MySQL 4.1.7 and the Query Browser and Admin tool.

I have noticed that when I create a foreign key via the browser or admin tool that the foreign key cannot be displayed again. However if I do a 'show' command the key is in the table but not with the name that I gave it.

Is this normal for this version? I realize that ver 5.0 is improving on foreign keys etc.

I just want to make sure that the keys are being built correctly as I cant find any show command that will display the foreign key with any 'on delete' or 'on update' information.

Thank you

Fred Wohlfert

Options: ReplyQuote

Written By
ForeignKey in 4.1.7 & Admin tool
December 07, 2004 08:38AM

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.