Secure 5.1: Couchbase dropQueryIndex

Couchbase dropQueryIndex

Last updated: July 13, 2026

Drops a primary or secondary N1QL query index from a Couchbase collection. Set isPrimary to true to drop the primary index, or false to drop a named secondary index.

Known limitations:

This operation is irreversible. There is no automatic rollback support.
Dropping the primary index causes queries without a matching secondary index to fail or fall back to a full collection scan.

Available attributes

Attribute	Type	Description	Required
`isPrimary`	Boolean	When `true`, drops the primary index. When `false`, drops the named secondary index specified by `indexName`.	Yes
`bucketName`	String	The name of the bucket containing the collection.	Yes
`scopeName`	String	The name of the scope containing the collection.	Yes
`collectionName`	String	The name of the collection whose index to drop.	Yes
`indexName`	String	The name of the secondary index to drop. Required when `isPrimary` is `false`. Omit when `isPrimary` is `true`.	No

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.19.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-couchbase-ext.xsd">

    <changeSet id="1" author="liquibase">
        <ext:dropQueryIndex>
            <ext:isPrimary>false</ext:isPrimary>
            <ext:indexName>myQueryIndex</ext:indexName>
            <ext:bucketName>myBucket</ext:bucketName>
            <ext:scopeName>myScope</ext:scopeName>
            <ext:collectionName>myCollection</ext:collectionName>
        </ext:dropQueryIndex>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "liquibase",
        "dropQueryIndex": {
          "isPrimary": false,
          "indexName": "myQueryIndex",
          "bucketName": "myBucket",
          "scopeName": "myScope",
          "collectionName": "myCollection"
        }
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: '1'
      author: liquibase
      dropQueryIndex:
        isPrimary: false
        indexName: myQueryIndex
        bucketName: myBucket
        scopeName: myScope
        collectionName: myCollection

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.19.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-couchbase-ext.xsd">

    <changeSet id="1" author="liquibase">
        <ext:dropQueryIndex>
            <ext:isPrimary>false</ext:isPrimary>
            <ext:indexName>myQueryIndex</ext:indexName>
            <ext:bucketName>myBucket</ext:bucketName>
            <ext:scopeName>myScope</ext:scopeName>
            <ext:collectionName>myCollection</ext:collectionName>
        </ext:dropQueryIndex>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "1",
        "author": "liquibase",
        "dropQueryIndex": {
          "isPrimary": false,
          "indexName": "myQueryIndex",
          "bucketName": "myBucket",
          "scopeName": "myScope",
          "collectionName": "myCollection"
        }
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: '1'
      author: liquibase
      dropQueryIndex:
        isPrimary: false
        indexName: myQueryIndex
        bucketName: myBucket
        scopeName: myScope
        collectionName: myCollection

Couchbase dropQueryIndex

Available attributes

XML example

JSON example

YAML example

More like this