Jump to content


Database Schema Myisam

  • Please log in to reply
1 reply to this topic

#1 Stephan123


    Advanced Member

  • Members
  • PipPipPip
  • 36 posts

Posted 08 September 2011 - 07:45 AM

Hello !

I have a database only with MyISAM tables.
I want the 'Database designers' use of the dependencies in the database display.
Unfortunately I can not work with foreign keys.
Can I move between the columns of the tables, a dotted line ?

Your sincerly


#2 peterlaursen


    Advanced Member

  • Admin
  • PipPipPip
  • 8,148 posts
  • Gender:Male
  • Location:Skagen, Denmark

Posted 08 September 2011 - 08:45 AM

Quote from documentation:

"Whatever you add or change from the Schema Designer will be stored to the database exactly the same way as when you work with the menu's of the program. There is no need to 'upload', 'apply', 'synchronize' the LAYOUT or anything like that. SQLyog Schema Designer is a graphical implementation of direct client functionalities. We work with the database that we are connected to - not with any kind of 'model' internal for the program"

.. and accordingly Foreign Key's are only supported in the Schema Desinger for the engines that support such (InnoDB, PBXT and (the now discontinued) SolidDB).

We have this recorded here alread: http://code.google.c.../detail?id=1642

.. but no guarantee that we will ever implement it. After all MyISAM is losing importance and also MySQL plan to implement FK's in the server layer for enignes that do not support in the engine layer. If and when this happes we will of course support it.

Computers make your grey hair come off ....

Peter Laursen

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users