alterSequence
Alters properties of an existing sequence.
Available attributes
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
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 |