Drop index is not working

N1QL
1

When I run
SELECT * FROM system:indexes WHERE name="indexName";
I get

[
{
“indexes”: {
“condition”: “(docType = “ABC”)”,
“datastore_id”: “http://127.0.0.1:8091”,
“id”: “bb6f23891470f893”,
“index_key”: [
"id"
],
“keyspace_id”: “id”,
“name”: “indexName”,
“namespace_id”: “default”,
“state”: “online”,
“using”: “gsi”
}
}
]

as result.
Now to drop this index I run DROP INDEX ‘indexName’ USING GSI; I get 3000 error.
I have no idea why this drop query is not working.

2

the statement is

DROP INDEX named_keyspace_ref.index_name

so you should try this

DROP INDEX `id`.`indexName` USING GSI;
3 Likes