Of course, I'd figure it out right after sending this. For the interested:
"alter table XYZ drop key foo;" Take care, --Noel ----- Original Message ----- 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