I'm trying to drop an index created on a table, but I get this error -

The operation 'ALTER TABLE DROP INDEX' is supported only with memory optimized tables.

I need to remove this index in order to drop a field in my table. Is there any way of doing this without duplicating the table, and migrating all the data across?

2 Answers

Lukasz Szozda On

For regular tables you should use DROP INDEX syntax:

DROP INDEX index_name ON tab_name;


The syntax ALTER TABLE ... ADD/DROP/ALTER INDEX is supported only for memory-optimized tables.

wosi On

Look here: if it is NOT a memory optimized table then just use the "drop index" statement.