Jump to content


Photo

Relationships Between Tables


  • Please log in to reply
3 replies to this topic

#1 Stephan123

Stephan123

    Member

  • Members
  • PipPip
  • 27 posts

Posted 01 September 2011 - 07:46 AM

Hello !

In my project I need to use 'MyISAM' tables.
Unfortunately these tables do not support foreign keys.
How can I display the dependencies of these tables in the designer?
I think of a dotted line.

Who can help with information ?

Your sincerly

Stephan

#2 kushal

kushal

    Newbie

  • Members
  • Pip
  • 1 posts
  • Gender:Male
  • Location:Bengaluru
  • Interests:Development , Testing, Designing , Management

Posted 02 September 2011 - 06:26 AM

Hi ,

which is the version you are using ?



Regards
Kushal

#3 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,868 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 02 September 2011 - 07:37 AM

In SQLyog Schema Designer this is not possible. The documentation says:

"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". So what is see in the Schema Designer is *what is in the database*.

There also is no option for user to draw his own graphics on top of the 'Layout'. (be it lines, text boxes with comments or whatever). We have discussed this before but we have no plans of implementing such in the foreseeable future.


Computers make your grey hair come off ....

Peter Laursen
Webyog

#4 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,868 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 02 September 2011 - 07:40 AM

I have added this here: http://code.google.c.../detail?id=1642

But don't expect it soon.


Computers make your grey hair come off ....

Peter Laursen
Webyog




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users