ForeignKey in 4.1.7 & Admin tool

[Fred Wohlfert]

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