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