Remove a flag from a table column?

[Dan Grossman]

Went back and removed most of this post.. it all comes down to.. how do I remove the UNIQUE flag from one of the columns in a table I made? I can't figure out the ALTER statement or whatever.

Thanks!

[DR_LaRRY_PEpPeR]

MySQL...?

that's a UNIQUE index. if the index was on the column `foo', and you didn't name the index something else, you can remove it with this query:

ALTER TABLE table DROP INDEX foo

this will also work:

DROP INDEX foo ON table

not sure which is the "standard" way.