What about:
alter table reviews change revr_nick revr_nick varchar(12) not null, add
unique (revr_nick);
Mike
Stephen F. Johnston Jr. wrote:
>
> hello all-
>
> I am trying to execute this command, any idea why it does not work?
>
> 'alter table reviews change column revr_nick UNIQUE revr_nick varchar(12)
> not null'
>
> I have tried other permutations including...
>
> 'alter table reviews change column revr_nick UNIQUE( revr_nick varchar(12)
> not null)'
>
> and
>
> 'alter table reviews change column revr_nick (UNIQUE revr_nick varchar(12)
> not null)'
>
> anyway.. anyone out there have my silver bullet. I am probably just reading
> the docs wrong......
