Delete N1ql query - cross scopes and collections


Is it possible to execute a delete N1ql query on a bucket to delete all documents from all its scopes/collection at once?

The use case is when user ask to be deleted from the system, we need the ability to do it with one query instead of sending the delete request to all of our tens of services to do it by scope and collection.


No, that’s not possible. The contents of collections are independent of buckets. (Bucket can be thought of more-or-less like an RDBMS database and a collection like an RDBMS table; there is no DELETE FROM DATABASE statement.)

(Ref: Buckets, Scopes and Collections | Couchbase Docs )