createSequence

Creates a new database sequence

Available attributes

Name Description Required Supports
Name Description Required for 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, h2, 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

XML example

<changeSet  author="liquibase-docs"  id="createSequence-example">  
    <createSequence  cacheSize="371717"  
            catalogName="cat"  
            cycle="true"  
            dataType="int"  
            incrementBy="2"  
            maxValue="1000"  
            minValue="10"  
            ordered="true"  
            schemaName="public"  
            sequenceName="seq_id"  
            startValue="5"/>  
</changeSet>

YAML example

changeSet:  
  id:  createSequence-example  
  author:  liquibase-docs  
  changes:  
  -  createSequence:  
      cacheSize:  371717  
      catalogName:  cat  
      cycle:  true  
      dataType:  int  
      incrementBy:  2  
      maxValue:  1000  
      minValue:  10  
      ordered:  true  
      schemaName:  public  
      sequenceName:  seq_id  
      startValue:  5

JSON example

{  "changeSet":  {  "id":  "createSequence-example",  "author":  "liquibase-docs",  "changes":  [  {  "createSequence":  {  "cacheSize":  371717,  "catalogName":  "cat",  "cycle":  true,  "dataType":  "int",  "incrementBy":  2,  "maxValue":  1000,  "minValue":  10,  "ordered":  true,  "schemaName":  "public",  "sequenceName":  "seq_id",  "startValue":  5  }  }]  }  }

SQL example

CREATE  SEQUENCE  [public].seq_id  AS  int  START  WITH  5  INCREMENT  BY  2  MINVALUE  10  MAXVALUE  1000  ORDER  CYCLE;

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