createSequence

Creates a new database sequence.

Available attributes

Name Description Required Supports
cacheSize Number of values to fetch per query 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 Interval between sequence numbers asany, db2, db2z, derby, h2, hsqldb, informix, mssql, oracle, postgresql
maxValue The maximum value of the sequence asany, db2, db2z, derby, h2, informix, mssql, oracle, postgresql
minValue The minimum value of the sequence asany, db2, db2z, derby, h2, informix, mssql, oracle, postgresql
ordered Does the sequence need to be guaranteed to be generated in the order of request? asany, db2, db2z, derby, firebird, h2, informix, mssql, oracle
schemaName Name of the schema all
sequenceName Name of the sequence to create all all
startValue The first sequence number to be generated. asany, db2, db2z, derby, h2, hsqldb, informix, mssql, oracle, postgresql

Database support

Database Notes Auto rollback
DB2/LUW Supported Yes
DB2/z Supported Yes
Derby Supported Yes
Firebird Supported Yes
H2 Supported Yes
HyperSQL Supported Yes
INGRES Not Supported Yes
Informix Supported Yes
MariaDB Not Supported Yes
MySQL Not Supported Yes
Oracle Supported Yes
PostgreSQL Supported Yes
SQL Server Supported Yes
SQLite Not Supported Yes
Sybase Not Supported Yes
Sybase Anywhere Supported Yes