Sequence (jOOQ 3.13.1 API)

All Superinterfaces:

Named, QueryPart, Serializable, Typed<T>

All Known Implementing Classes:

SequenceImpl
```
public interface Sequence<T extends Number>
extends Named, Typed<T>
```
A sequence.
Instances can be created using DSL.sequence(Name) and overloads.

Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`Field<T>`	`currval()`	Get the current value of this sequence
`Field<T>`	`getCache()`	Get the number of sequence values to cache for this sequence or `null`, if no such value is specified.
`Catalog`	`getCatalog()`	Get the sequence catalog.
`boolean`	`getCycle()`	Returns `true` if this sequence cycles to `getMinvalue()` when it reaches `getMaxvalue()`.
`Field<T>`	`getIncrementBy()`	Get the increment for this sequence or `null`, if no such value is specified.
`Field<T>`	`getMaxvalue()`	Get the maximum value for this sequence or `null`, if no such value is specified.
`Field<T>`	`getMinvalue()`	Get the minimum value for this sequence or `null`, if no such value is specified.
`Schema`	`getSchema()`	Get the sequence schema.
`Field<T>`	`getStartWith()`	Get the start value for this sequence or `null`, if no such value is specified.
`Field<T>`	`nextval()`	Increment the sequence and get the next value

Methods inherited from interface org.jooq.Named
getComment, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString

Methods inherited from interface org.jooq.Typed
getBinding, getConverter, getDataType, getDataType, getType

- Method Detail
  - getCatalog
```
Catalog getCatalog()
```
    Get the sequence catalog.
  - getSchema
```
Schema getSchema()
```
    Get the sequence schema.
  - getStartWith
```
Field<T> getStartWith()
```
    Get the start value for this sequence or null, if no such value is specified.
  - getIncrementBy
```
Field<T> getIncrementBy()
```
    Get the increment for this sequence or null, if no such value is specified.
  - getMinvalue
```
Field<T> getMinvalue()
```
    Get the minimum value for this sequence or null, if no such value is specified.
  - getMaxvalue
```
Field<T> getMaxvalue()
```
    Get the maximum value for this sequence or null, if no such value is specified.
  - getCycle
```
boolean getCycle()
```
    Returns true if this sequence cycles to getMinvalue() when it reaches getMaxvalue().
  - getCache
```
Field<T> getCache()
```
    Get the number of sequence values to cache for this sequence or null, if no such value is specified.
  - currval
```
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
Field<T> currval()
```
    Get the current value of this sequence
  - nextval
```
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
Field<T> nextval()
```
    Increment the sequence and get the next value