alterSequence

Alters properties of an existing sequence.

Available attributes

Name Description Required for Supports
cacheSize Change the cache size? all
catalogName Name of the catalog all
cycle Can the sequence cycle when it hits the max value? all
dataType Data type of the sequence asany, db2z, derby, firebird, h2, informix, postgresql
incrementBy New amount the sequence should increment by asany, db2, db2z, derby, firebird, informix, mssql, oracle, postgresql
maxValue New maximum value for the sequence asany, db2, db2z, derby, firebird, h2, informix, mssql, oracle, postgresql
minValue New minimum value for the sequence all
ordered Does the sequence need to be guaranteed to be generated in the order of request? asany, db2z, derby, firebird, h2, informix, mssql, oracle, postgresql
schemaName Name of the schema all
sequenceName Name of the sequence to alter all all

XML example

<changeSet  author="liquibase-docs"  id="alterSequence-example">  
    <alterSequence  cacheSize="371717"  
            catalogName="cat"  
            cycle="true"  
            dataType="int"  
            incrementBy="371717"  
            maxValue="371717"  
            minValue="371717"  
            ordered="true"  
            schemaName="public"  
            sequenceName="seq_id"/>  
</changeSet>

YAML example

changeSet:  
  id:  alterSequence-example  
  author:  liquibase-docs  
  changes:  
  -  alterSequence:  
      cacheSize:  371717  
      catalogName:  cat  
      cycle:  true  
      dataType:  int  
      incrementBy:  371717  
      maxValue:  371717  
      minValue:  371717  
      ordered:  true  
      schemaName:  public  
      sequenceName:  seq_id

JSON example

{  "changeSet":  {  "id":  "alterSequence-example",  "author":  "liquibase-docs",  "changes":  [  {  "alterSequence":  {  "cacheSize":  371717,  "catalogName":  "cat",  "cycle":  true,  "dataType":  "int",  "incrementBy":  371717,  "maxValue":  371717,  "minValue":  371717,  "ordered":  true,  "schemaName":  "public",  "sequenceName":  "seq_id"  }  }]  }  }

SQL example

ALTER  SEQUENCE  [public].seq_id  AS  int  INCREMENT  BY  371717  MINVALUE  371717  MAXVALUE  371717  ORDER;

Database support

Database Notes Auto rollback
DB2/LUW Supported No
DB2/z Supported No
Derby Supported No
Firebird Supported No
H2 Supported No
HyperSQL Supported No
INGRES Not Supported No
Informix Supported No
MariaDB Not Supported No
MySQL Not Supported No
Oracle Supported No
PostgreSQL Supported No
SQL Server Supported No
SQLite Not Supported No
Sybase Not Supported No
Sybase Anywhere Supported No