Change: ‘dropIndex’

Drops an existing index

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall3.0
indexNameName of the index to dropallall
schemaNameName of the schemaall
tableNameName fo the indexed table.mssql, mysqlall
<changeSet author="liquibase-docs" id="dropIndex-example">
    <dropIndex catalogName="cat"
            indexName="idx_address"
            schemaName="public"
            tableName="person"/>
</changeSet>
changeSet:
  id: dropIndex-example
  author: liquibase-docs
  changes:
  - dropIndex:
      catalogName: cat
      indexName: idx_address
      schemaName: public
      tableName: person
{
  "changeSet": {
    "id": "dropIndex-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "dropIndex": {
          "catalogName": "cat",
          "indexName": "idx_address",
          "schemaName": "public",
          "tableName": "person"
        }
      }]
    
  }
}

SQL Generated From Above Sample (MySQL)

DROP INDEX idx_address ON cat.person;

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DerbySupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
InformixSupportedNo
MySQLSupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerSupportedNo
SQLiteSupportedNo
SybaseSupportedNo
Sybase AnywhereSupportedNo

Missing, incomplete or wrong information? Please send a pull request