Snowflake alterSequence

Last updated: March 26, 2026

Modifies properties of an existing sequence in Snowflake. This allows you to change the increment value and ordering behavior without recreating the sequence.

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

Known limitation: The Liquibase alterSequence 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 that you are using the Snowflake alterSequence change type and breaks backwards compatibility with the Liquibase alterSequence 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 alter	Yes
`ifExists`	Boolean	Don't error if the sequence doesn't exist using IF EXISTS	No
`incrementBy`	Long	New value to increment by for each sequence value*	No
`ordered`	Boolean	New ordering behavior (true for ORDER, false for NOORDER)*	No

* At least one of incrementBy or ordered must be specified.

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

    <!-- Change increment -->
    <changeSet id="alter-sequence-increment" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                incrementBy="10"/>
    </changeSet>

    <!-- Change ordering -->
    <changeSet id="alter-sequence-ordering" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                ordered="false"/>
    </changeSet>

    <!-- Change both with IF EXISTS -->
    <changeSet id="alter-sequence-both" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="INVOICE_SEQ"
                ifExists="true"
                incrementBy="5"
                ordered="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "alter-sequence-increment",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "incrementBy": 10
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-ordering",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "ordered": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-both",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "INVOICE_SEQ",
              "ifExists": true,
              "incrementBy": 5,
              "ordered": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Change increment
  - changeSet:
      id: alter-sequence-increment
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            incrementBy: 10

  # Change ordering
  - changeSet:
      id: alter-sequence-ordering
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            ordered: false

  # Change both with IF EXISTS
  - changeSet:
      id: alter-sequence-both
      author: examples
      changes:
        - alterSequence:
            sequenceName: INVOICE_SEQ
            ifExists: true
            incrementBy: 5
            ordered: true

--liquibase formatted sql

--changeset examples:change-increment
-- Change increment
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET INCREMENT BY 10;

--changeset examples:change-ordering
-- Change ordering
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET NOORDER;

--changeset examples:change-both-with-if-exists
-- Change both with IF EXISTS
ALTER SEQUENCE IF EXISTS PUBLIC.INVOICE_SEQ SET INCREMENT BY 5 ORDER;

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

    <!-- Change increment -->
    <changeSet id="alter-sequence-increment" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                incrementBy="10"/>
    </changeSet>

    <!-- Change ordering -->
    <changeSet id="alter-sequence-ordering" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                ordered="false"/>
    </changeSet>

    <!-- Change both with IF EXISTS -->
    <changeSet id="alter-sequence-both" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="INVOICE_SEQ"
                ifExists="true"
                incrementBy="5"
                ordered="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "alter-sequence-increment",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "incrementBy": 10
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-ordering",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "ordered": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-both",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "INVOICE_SEQ",
              "ifExists": true,
              "incrementBy": 5,
              "ordered": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Change increment
  - changeSet:
      id: alter-sequence-increment
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            incrementBy: 10

  # Change ordering
  - changeSet:
      id: alter-sequence-ordering
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            ordered: false

  # Change both with IF EXISTS
  - changeSet:
      id: alter-sequence-both
      author: examples
      changes:
        - alterSequence:
            sequenceName: INVOICE_SEQ
            ifExists: true
            incrementBy: 5
            ordered: true

--liquibase formatted sql

--changeset examples:change-increment
-- Change increment
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET INCREMENT BY 10;

--changeset examples:change-ordering
-- Change ordering
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET NOORDER;

--changeset examples:change-both-with-if-exists
-- Change both with IF EXISTS
ALTER SEQUENCE IF EXISTS PUBLIC.INVOICE_SEQ SET INCREMENT BY 5 ORDER;

Snowflake alterSequence

Available attributes

XML

JSON

YAML

SQL

More like this