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 limitation: This change type does not support 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
`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