Drop all indexes


Is there a way to drop all indexes of a couchbase bucket with one query?

Unfortunately, this is not possible for now.

any news about that?

you can drop only one index at time.

Any chance this will be worked on some day? It sure would be nice for a bunch of reasons.

Will be able to provide reasons. Constraints or references (when added to product) can interfere.

You can achieve this with simple script by getting all indexes and calling one by one using python
The following SQL gives array of drop statements for default bucket.

 SELECT RAW "DROP INDEX `" || keyspace_id || "`.`" || name || "`;" 
FROM system:indexes 
WHERE keyspace_id = "default";