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 |

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

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

{
"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"
}
}
]
}
}

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 |