alterSequence

Alters properties of an existing sequence.

Available attributes

Name	Description	Required for	Supports
`cacheSize`	Change the cache size		asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase
`catalogName`	Name of the catalog		asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase
`cycle`	Can the sequence cycle when it hits the max value?		asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase
`dataType`	Data type of the sequence		asany, derby, informix, postgresql
`incrementBy`	New amount the sequence should increment by		asany, db2, db2z, derby, informix, mssql, oracle, postgresql
`maxValue`	New maximum value for the sequence		asany, db2, db2z, derby, h2, informix, mssql, oracle, postgresql
`minValue`	New minimum value for the sequence		asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase
`ordered`	Does the sequence need to be guaranteed to be generated in the order of request?		asany, db2z, derby, h2, informix, oracle, postgresql
`schemaName`	Name of the schema		asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase
`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
Snowflake	Supported	No
SQL Server	Supported	No
SQLite	Not Supported	No
Sybase	Not Supported	No
Sybase Anywhere	Supported	No