dropSequence - Liquibase

Snowflake dropSequence

Last updated: March 26, 2026

Drops an existing sequence in Snowflake.

Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).

Known issue: The Liquibase dropSequence change type is not compatible for Snowflake users in Liquibase Secure 5.1 using YAML or JSON change type formats. This does not affect XML change types at all. If you’re connecting to a Snowflake database, Liquibase automatically detects you are using the Snowflake dropSequence change type and breaks backwards compatibility with the Liquibase dropSequence change type. We recommend upgrading to Liquibase Secure 5.1.1 to use createView with YAML and JSON change type formats successfully.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the sequence	No
`schemaName`	String	Name of the schema containing the sequence	No
`sequenceName`	String	Name of the sequence to drop	Yes
`ifExists`	Boolean	Don't error if the sequence doesn't exist using IF EXISTS	No
`dropMode`	String	CASCADE (drop dependent objects) or RESTRICT (fail if dependencies)	No

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

    <!-- Basic drop -->
    <changeSet id="drop-sequence" author="examples">
        <pro-snowflake:dropSequence sequenceName="OLD_SEQUENCE"/>
    </changeSet>

    <!-- Drop with IF EXISTS -->
    <changeSet id="drop-sequence-if-exists" author="examples">
        <pro-snowflake:dropSequence
                sequenceName="TEMP_SEQUENCE"
                ifExists="true"/>
    </changeSet>

    <!-- Drop with CASCADE -->
    <changeSet id="drop-sequence-cascade" author="examples">
        <pro-snowflake:dropSequence
                sequenceName="LEGACY_SEQUENCE"
                ifExists="true"
                dropMode="CASCADE"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-sequence",
        "author": "examples",
        "changes": [
          {
            "dropSequence": {
              "sequenceName": "OLD_SEQUENCE"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-sequence-if-exists",
        "author": "examples",
        "changes": [
          {
            "dropSequence": {
              "sequenceName": "TEMP_SEQUENCE",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-sequence-cascade",
        "author": "examples",
        "changes": [
          {
            "dropSequence": {
              "sequenceName": "LEGACY_SEQUENCE",
              "ifExists": true,
              "dropMode": "CASCADE"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic drop
  - changeSet:
      id: drop-sequence
      author: examples
      changes:
        - dropSequence:
            sequenceName: OLD_SEQUENCE

  # Drop with IF EXISTS
  - changeSet:
      id: drop-sequence-if-exists
      author: examples
      changes:
        - dropSequence:
            sequenceName: TEMP_SEQUENCE
            ifExists: true

  # Drop with CASCADE
  - changeSet:
      id: drop-sequence-cascade
      author: examples
      changes:
        - dropSequence:
            sequenceName: LEGACY_SEQUENCE
            ifExists: true
            dropMode: CASCADE

--liquibase formatted sql

--changeset examples:basic-drop
-- Basic drop
DROP SEQUENCE PUBLIC.OLD_SEQUENCE;

--changeset examples:drop-with-if-exists
-- Drop with IF EXISTS
DROP SEQUENCE IF EXISTS PUBLIC.TEMP_SEQUENCE;

--changeset examples:drop-with-cascade
-- Drop with CASCADE
DROP SEQUENCE IF EXISTS PUBLIC.LEGACY_SEQUENCE CASCADE;

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

    <!-- Basic drop -->
    <changeSet id="drop-sequence" author="examples">
        <pro-snowflake:dropSequence sequenceName="OLD_SEQUENCE"/>
    </changeSet>

    <!-- Drop with IF EXISTS -->
    <changeSet id="drop-sequence-if-exists" author="examples">
        <pro-snowflake:dropSequence
                sequenceName="TEMP_SEQUENCE"
                ifExists="true"/>
    </changeSet>

    <!-- Drop with CASCADE -->
    <changeSet id="drop-sequence-cascade" author="examples">
        <pro-snowflake:dropSequence
                sequenceName="LEGACY_SEQUENCE"
                ifExists="true"
                dropMode="CASCADE"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-sequence",
        "author": "examples",
        "changes": [
          {
            "dropSequence": {
              "sequenceName": "OLD_SEQUENCE"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-sequence-if-exists",
        "author": "examples",
        "changes": [
          {
            "dropSequence": {
              "sequenceName": "TEMP_SEQUENCE",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-sequence-cascade",
        "author": "examples",
        "changes": [
          {
            "dropSequence": {
              "sequenceName": "LEGACY_SEQUENCE",
              "ifExists": true,
              "dropMode": "CASCADE"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic drop
  - changeSet:
      id: drop-sequence
      author: examples
      changes:
        - dropSequence:
            sequenceName: OLD_SEQUENCE

  # Drop with IF EXISTS
  - changeSet:
      id: drop-sequence-if-exists
      author: examples
      changes:
        - dropSequence:
            sequenceName: TEMP_SEQUENCE
            ifExists: true

  # Drop with CASCADE
  - changeSet:
      id: drop-sequence-cascade
      author: examples
      changes:
        - dropSequence:
            sequenceName: LEGACY_SEQUENCE
            ifExists: true
            dropMode: CASCADE

--liquibase formatted sql

--changeset examples:basic-drop
-- Basic drop
DROP SEQUENCE PUBLIC.OLD_SEQUENCE;

--changeset examples:drop-with-if-exists
-- Drop with IF EXISTS
DROP SEQUENCE IF EXISTS PUBLIC.TEMP_SEQUENCE;

--changeset examples:drop-with-cascade
-- Drop with CASCADE
DROP SEQUENCE IF EXISTS PUBLIC.LEGACY_SEQUENCE CASCADE;

Snowflake dropSequence

Available attributes

XML

JSON

YAML

SQL

More like this