Liquibase® version 3.8.1 is now available! Get it for free.
2018 XML Announcement
News Liquibase 3.8.1 Released
06 Nov 2019

- and/or -

All Previous Posts >>

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"
        objectQuotingStrategy="LEGACY">
    <dropSequence catalogName="cat"
            schemaName="public"
            sequenceName="seq_id"/>
</changeSet>
changeSet:
  id: dropSequence-example
  author: liquibase-docs
  objectQuotingStrategy: LEGACY
  changes:
  - dropSequence:
      catalogName: cat
      schemaName: public
      sequenceName: seq_id
{
  "changeSet": {
    "id": "dropSequence-example",
    "author": "liquibase-docs",
    "objectQuotingStrategy": "LEGACY",
    "changes": [
      {
        "dropSequence": {
          "catalogName": "cat",
          "schemaName": "public",
          "sequenceName": "seq_id"
        }
      }]
    
  }
}

SQL Generated From Above Sample (SQL Server)

DROP SEQUENCE [public].seq_id;

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DB2SupportedNo
DerbySupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
INGRESNot SupportedNo
InformixSupportedNo
MariaDBNot SupportedNo
MySQLNot SupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerSupportedNo
SQLiteNot SupportedNo
SybaseNot SupportedNo
Sybase AnywhereSupportedNo