Jump to content


Photo

Database Schema Myisam


  • Please log in to reply
1 reply to this topic

#1 Stephan123

Stephan123

    Member

  • Members
  • PipPip
  • 27 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

Stephan

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

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
Webyog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users