> Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem
> annoyed, but I have used for quite some time a few GUI clients, notably
> MySQL-Front, which I were relatively confortable with. Anyway, all GUI
> clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be
> some sort of shortcut to the MySQL command line. No problem with that,
> that's what I am looking for and not some high-level CASE tool.
> It's when looking for foreign keys and referential integrity where
> tools fail miserably. None of them fully supports editing / creating /
> deleting foreign keys. If you are to reply to this message, please read
> again the "FULLY supports" statement. For example, with version 1.0.7-beta
> of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an "ON
> constraint... silly, huh? This is not a strange "Fails when lib-foo
> v126.96.36.199.7 connects throu a CISCO 90238234 router in a full moon night"
> error, it's simply that the programmer (nor the bug-testing labs) have not
> tried the "On Update:" drop-down menu from the edit table dialog.
> I know foreign keys are a relatively new area in the MySQL field and
> maybe the programmers are slowly adding support for it, but it's quite
> annoying to see monumental bugs editing and changing foreign keys in ALL
> programs I've tried.
> Please, note that this message is not intended to flame anyone. I
> aknowledge the effort involved creating such a tool, I'm a programmer
> all, and some of them are in beta anyway. I would appreciate if anyone
> some tool which good foreign key support.
Well, you still need to manually create indices - but the FKs
work just fine in ... Database Workbench - www.upscene.com
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL