alterSequence

Alter 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