Snowflake renameSequence

Last updated: March 26, 2026

Last updated: March 25, 2026

Renames an existing sequence in Snowflake.

Note: Automatic rollback renames the sequence back to original name.

Known limitations:

This change type does not support database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).
The Liquibase renameSequence 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 renameSequence change type and breaks backwards compatibility with the Liquibase renameSequence 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
`oldSequenceName`	String	Current name of the sequence	Yes
`newSequenceName`	String	New name for the sequence	Yes
`ifExists`	Boolean	Don't error if the sequence doesn't exist	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">

    <!-- Simple rename -->
    <changeSet id="rename-sequence" author="examples">
        <pro-snowflake:renameSequence
                oldSequenceName="OLD_SEQ"
                newSequenceName="NEW_SEQ"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-sequence-if-exists" author="examples">
        <pro-snowflake:renameSequence
                oldSequenceName="TEMP_SEQ"
                newSequenceName="PERMANENT_SEQ"
                ifExists="true"/>
    </changeSet>

    <!-- Rename with schema qualification -->
    <changeSet id="rename-sequence-with-schema" author="examples">
        <pro-snowflake:renameSequence
                schemaName="ANALYTICS"
                oldSequenceName="ORDER_SEQ"
                newSequenceName="INVOICE_SEQ"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-sequence",
        "author": "examples",
        "changes": [
          {
            "renameSequence": {
              "oldSequenceName": "OLD_SEQ",
              "newSequenceName": "NEW_SEQ"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-sequence-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameSequence": {
              "oldSequenceName": "TEMP_SEQ",
              "newSequenceName": "PERMANENT_SEQ",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-sequence-with-schema",
        "author": "examples",
        "changes": [
          {
            "renameSequence": {
              "schemaName": "ANALYTICS",
              "oldSequenceName": "ORDER_SEQ",
              "newSequenceName": "INVOICE_SEQ"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple rename
  - changeSet:
      id: rename-sequence
      author: examples
      changes:
        - renameSequence:
            oldSequenceName: OLD_SEQ
            newSequenceName: NEW_SEQ

  # Rename with IF EXISTS
  - changeSet:
      id: rename-sequence-if-exists
      author: examples
      changes:
        - renameSequence:
            oldSequenceName: TEMP_SEQ
            newSequenceName: PERMANENT_SEQ
            ifExists: true

  # Rename with schema qualification
  - changeSet:
      id: rename-sequence-with-schema
      author: examples
      changes:
        - renameSequence:
            schemaName: ANALYTICS
            oldSequenceName: ORDER_SEQ
            newSequenceName: INVOICE_SEQ

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER SEQUENCE PUBLIC.OLD_SEQ RENAME TO NEW_SEQ;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER SEQUENCE IF EXISTS PUBLIC.TEMP_SEQ RENAME TO PERMANENT_SEQ;

--changeset examples:rename-with-schema-qualification
-- Rename with schema qualification
ALTER SEQUENCE ANALYTICS.ORDER_SEQ RENAME TO INVOICE_SEQ;

<?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">

    <!-- Simple rename -->
    <changeSet id="rename-sequence" author="examples">
        <pro-snowflake:renameSequence
                oldSequenceName="OLD_SEQ"
                newSequenceName="NEW_SEQ"/>
    </changeSet>

    <!-- Rename with IF EXISTS -->
    <changeSet id="rename-sequence-if-exists" author="examples">
        <pro-snowflake:renameSequence
                oldSequenceName="TEMP_SEQ"
                newSequenceName="PERMANENT_SEQ"
                ifExists="true"/>
    </changeSet>

    <!-- Rename with schema qualification -->
    <changeSet id="rename-sequence-with-schema" author="examples">
        <pro-snowflake:renameSequence
                schemaName="ANALYTICS"
                oldSequenceName="ORDER_SEQ"
                newSequenceName="INVOICE_SEQ"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-sequence",
        "author": "examples",
        "changes": [
          {
            "renameSequence": {
              "oldSequenceName": "OLD_SEQ",
              "newSequenceName": "NEW_SEQ"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-sequence-if-exists",
        "author": "examples",
        "changes": [
          {
            "renameSequence": {
              "oldSequenceName": "TEMP_SEQ",
              "newSequenceName": "PERMANENT_SEQ",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-sequence-with-schema",
        "author": "examples",
        "changes": [
          {
            "renameSequence": {
              "schemaName": "ANALYTICS",
              "oldSequenceName": "ORDER_SEQ",
              "newSequenceName": "INVOICE_SEQ"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple rename
  - changeSet:
      id: rename-sequence
      author: examples
      changes:
        - renameSequence:
            oldSequenceName: OLD_SEQ
            newSequenceName: NEW_SEQ

  # Rename with IF EXISTS
  - changeSet:
      id: rename-sequence-if-exists
      author: examples
      changes:
        - renameSequence:
            oldSequenceName: TEMP_SEQ
            newSequenceName: PERMANENT_SEQ
            ifExists: true

  # Rename with schema qualification
  - changeSet:
      id: rename-sequence-with-schema
      author: examples
      changes:
        - renameSequence:
            schemaName: ANALYTICS
            oldSequenceName: ORDER_SEQ
            newSequenceName: INVOICE_SEQ

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER SEQUENCE PUBLIC.OLD_SEQ RENAME TO NEW_SEQ;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER SEQUENCE IF EXISTS PUBLIC.TEMP_SEQ RENAME TO PERMANENT_SEQ;

--changeset examples:rename-with-schema-qualification
-- Rename with schema qualification
ALTER SEQUENCE ANALYTICS.ORDER_SEQ RENAME TO INVOICE_SEQ;

Snowflake renameSequence

Available attributes

XML

JSON

YAML

SQL

More like this