How do I change the "Indexed: Yes (No Duplicates)" constraint in Access to "Indexed: No" via SQL?

Question

I need to change a column in MS Access from indexed to non-indexed.

I need to do this via SQL because I do not have direct access to the database. I only have access to it via SQL.

How do I do this?

Answer 1

See: http://stackoverflow.com/questions/3468774/how-do-i-drop-and-unamed-relationship-constraint-in-ms-access-with-sql/3468984#3468984

Answer 2

In ANSI-92 Query Mode, a unique constraint is synonymous with a unique index, hence there are two syntaxes that both do the same thing:

ALTER TABLE TestMyIndex DROP
   CONSTRAINT uq__TestMyIndex__col1;

DROP INDEX uq__TestMyIndex__col1 
   ON TestMyIndex;

For a non-unique index, you must use DROP INDEX.