createSequence

Creates a new database sequence.

Available attributes

Name Description Required Supports
cacheSize Number of values to fetch per query 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, db2z, derby, 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, h2, informix, oracle
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 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 No
Informix Supported Yes
MariaDB Not Supported No
MySQL Not Supported No
Oracle Supported Yes
PostgreSQL Supported Yes
Snowflake Supported Yes
SQL Server Supported Yes
SQLite Not Supported No
Sybase Not Supported No
Sybase Anywhere Supported Yes