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).

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