nemanjko wrote on Feb 27 2006, 12:23 PM:
Hi,
I am using free edition of MySQL GUI v5.02 with MySQL database version 4.1.13a-nt.
The problem I see is that I cannot edit foreign keys. I can delete them and create a new one. Is this because I am using free edition or some bug/unfinished thing ?
Thanks,
Nemanja.
[post=”8949″]<{POST_SNAPBACK}>[/post]
Editing for FK is not supported in SQLyog. This is in our TO-DO list.
It is due to the reason that there is no way to alter foreign key instead u can drop and create a new one. We will be providing a GUI for the same in one of the later versions of SQLyog.
Right now you will need to:
DROP FOREIGN KEY constraint
ADD FOREIGN KEY.