Change: ‘dropSequence’

Drop an existing sequence

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall3.0
schemaNameName of the schemaall
sequenceNameName of the sequence to dropallall
<changeSet author="liquibase-docs" id="dropSequence-example">
    <dropSequence catalogName="cat"
            schemaName="public"
            sequenceName="seq_id"/>
</changeSet>
changeSet:
  id: dropSequence-example
  author: liquibase-docs
  changes:
  - dropSequence:
      catalogName: cat
      schemaName: public
      sequenceName: seq_id
{
  "changeSet": {
    "id": "dropSequence-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "dropSequence": {
          "catalogName": "cat",
          "schemaName": "public",
          "sequenceName": "seq_id"
        }
      }]
    
  }
}

SQL Generated From Above Sample (Oracle)

DROP SEQUENCE cat.seq_id;

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DerbyNot SupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
InformixSupportedNo
MySQLNot SupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerNot SupportedNo
SQLiteNot SupportedNo
SybaseNot SupportedNo
Sybase AnywhereNot SupportedNo

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