How to assign a key on a field?

[jayarjo]

I wanted to assign UNIQUE key to a particular field and suddenly found
out that I do not know how. I double-clicked on key column, but there
was no reaction whatsoever. Dialog for PRIMARY KEY usually pops out
automatically when I create first auto_increment field, but how do I
trigger it manually?

[Jeremy Burns | Class Outfit]

You assign a unique key via the index pane underneath the fields in structure view. Or, go to the 'extra' column in structure view, set it to auto-increment and it will prompt you to make it the primary key.

Jeremy Burns
Class Outfit

jerem...@classoutfit.com
http://www.classoutfit.com

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To post to this group, send email to seque...@googlegroups.com.
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.
>

[jayarjo]

Oh... right... haven't noticed it. Easy... Created now :) although if
double-click on key column could show that dialog too, could be even
easier :)

Thanks for great product.

On Nov 5, 10:23 pm, Jeremy Burns | Class Outfit

<jeremybu...@classoutfit.com> wrote:
> You assign a unique key via the index pane underneath the fields in structure view. Or, go to the 'extra' column in structure view, set it to auto-increment and it will prompt you to make it the primary key.
>
> Jeremy Burns
> Class Outfit
>

> jeremybu...@classoutfit.comhttp://www.classoutfit.com

[Rohit Gupta]

ALTER TABLE table_name ADD UNIQUE (column_name);