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

Unique Key

forums › forums › SQLyog › Using SQLyog › Unique Key

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 4, 2005 at 10:45 pm #9149
      energylevel
      Member

      In PHPMyAdmin there is an option to set a field as Unique, I can't see this option in SQLYog 4.07 ??? Have I missed something??

    • August 4, 2005 at 10:58 pm #18857
      peterlaursen
      Participant

      You have missed something!

      It is in “manage indexes” from table menu or in the context menu of a table.

      I don't recall exactly what PhpAdmin does, but if it offers you to create a “unique field” it is terminology mismatch. The right way to express it is that you build a unique index with one column/field.

      It looks like below

      For some strange reason it is common to speak of “Primary Key” and “Unique index” …

    • August 5, 2005 at 10:57 am #18858
      energylevel
      Member

      Thanks … I don't use SQLYog very often … I would say to a guy who have the techbialc expertise you do in this area, it seems to ot would be more user friendly to have this option in the alter table screen with the pother checkboxes ??

      Thanks Again

    • August 5, 2005 at 11:01 am #18859
      peterlaursen
      Participant

      hhmmm

      as long as you build indexes based on one column only that could be done too. But how would you then define an unique index built from more columns ?

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