Unsupported Screen Size: The viewport size is too small for the theme to render properly.

How To Add One-To-Many Relationship In Sqlyog ?

forums › forums › SQLyog › Using SQLyog › How To Add One-To-Many Relationship In Sqlyog ?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 6, 2013 at 12:05 pm #12919
      sanko
      Member

      hi,

      I add foreign key through SQLYog Manage Relationship menu on right click on a table.

      But I don't know how to add relationship multiplicy i.e one to Many …..Is it possible ? how ?

      Also why there is no icon/sign displayed on foreign key ?

    • February 6, 2013 at 12:21 pm #34154
      peterlaursen
      Participant

      It is the type of indexes on the tables that defines if it is one-to-one or one-to-may etc. If there is a UNIQUE CONSTRAINT of any kind (Primary Key, Unique Index) it will be 'one'. If there is no UNIQUE CONSTRAINT it will be 'many'.

      Where do you expect an icon?

    • February 7, 2013 at 12:32 pm #34155
      sanko
      Member

      >>>Where do you expect an icon?

      next to foreign key.

      there is a lock symbol next to primary key ….but there is no symbol next to foreign key ……

    • February 8, 2013 at 6:53 am #34156
      sathish
      Member

      Hello,

      We will not be to providing an icon for foreign keys and also most database tools indicate the Primary key only (Access for instance). If we do so, we would then have to provide a similar one for Uniqe index, Fulltext Index, and so on, which would be too much.

      Regards,

      Sathish

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.