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

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