createSequence
Creates a new database sequence.
Run createSequence
To run this Change Type, follow these steps:
Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the
updatecommand:liquibase update
Available attributes
Name | Description | Required | Supports |
| Number of values to fetch per query | asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase | |
| Name of the catalog | asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase | |
| Boolean. 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 | |
| Data type of the sequence | asany, db2z, derby, postgresql | |
| Integer amount to increment by at each call | asany, db2, db2z, derby, h2, hsqldb, informix, mssql, oracle, postgresql | |
| Sets the maximum value of the sequence | asany, db2, db2z, derby, h2, informix, mssql, oracle, postgresql | |
| Sets the minimum value of the sequence | asany, db2, db2z, derby, h2, informix, mssql, oracle, postgresql | |
| Boolean. Does the sequence need to be guaranteed to be generated in the order of request? | asany, db2, db2z, derby, h2, informix, oracle | |
| Name of the schema | asany, db2, db2z, derby, h2, hsqldb, informix, ingres, mariadb, mssql, mysql, oracle, postgresql, sqlite, sybase | |
| Name of the sequence | all | all |
| Initial integer value of the increment | asany, db2, db2z, derby, h2, hsqldb, informix, mssql, oracle, postgresql |
Database support
Database | Notes | |
DB2/LUW | Supported | Yes |
DB2/z | Supported | Yes |
Derby | Supported | Yes |
Firebird | Supported | Yes |
Google BigQuery | 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 |
createSequence examples
--liquibase formatted sql
--changeset liquibase-docs:createSequence-example
CREATE SEQUENCE [public].seq_id AS int START WITH 5 INCREMENT BY 2 MINVALUE 10 MAXVALUE 1000 ORDER CYCLE;