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

creation of "primary keys"

forums › forums › SQLyog › Using SQLyog › creation of "primary keys"

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 7, 2004 at 8:32 pm #8598
      dcayce
      Member

      Once a table has been created using SQLyog it seems that I can not go back and add a primary key to that table.

      Am I doing something wrong or is this a “feature” of mySQL or SQLyog.

      Not real important just a pain in the “…”

      Thanks

      Don

    • October 8, 2004 at 4:11 am #16360
      Ritesh
      Member

      Just select the table in the ObjectBrowser and select Alter Table Structure… from the popup menu (or press F6). Check the corresponding PK? checkboxes for the columns on which you want to create the keys.

      After you are done, click Alter Table

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