Hi all,

Hopefully a simple question for anyone who cares to take a swing at it:

Given an existing table with a field defined as:

"foo" char(60) not null unique 

What would be the proper syntax for an ALTER TABLE statement, to remove the unique 
constraint / key on this field?  A "modify" doesn't seem to cut it...  There *is* data 
that prevents me from just wiping out the field and creating a new one.  Going from 
unique TO a non-unique field shouldn't pose any data-conversion issues - so its GOT to 
be possible...  I just don't know how. :-P

Thanks, take care,

--Noel

Reply via email to