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