Need to remove column Uniqueness

[mhamilton3]

I have a column that is listed as Unique and I need to remove that. I can not figure out how to do it with without creating a new column, copying the old data in, deleting the old, and renaming the new. Any suggestions?

 

[piti]

if a column is marked as unique, there is a unique index created, so just drop that index

e.g.:
ATLER TABLE tablename DROP INDEX indexname

where indexname is often equal to the column name

 

[mhamilton3]

Thank you, that did it. FYI: The Alter table syntax did not work, but DROP INDEX Indexname on tablename did. I'm good to go.