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

Foreign Key

forums › forums › SQLyog › Using SQLyog › Foreign Key

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 15, 2007 at 3:25 pm #10239
      Rama Krishna
      Member

      Hi,

      How can we create foreign key for a table in mysql yog using GUI based table creation wizard. Please send me the reply to my email Id : [email protected]

    • March 16, 2007 at 4:04 am #23604
      peterlaursen
      Participant

      We do not reply to emails.  We reply in the Forums itself.  That is the idea with a Forum!

      To create a Foreign Key you will first have to

      1) create the' parent' and the 'child table'

      2) next select 'manage foreign keys' in the child table context menu and select the column in the parent table that shall be the FK of the child column

      3) Note that with older MySQL versions you will first need to create indexes manually on the two columns

      Please refer to the program help file.  Everything is explained here.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.