Module org.jooq

Package org.jooq

Interface AlterSequenceFlagsStep

All Superinterfaces:

AlterSequenceFinalStep, Attachable, AutoCloseable, DDLQuery, Flow.Publisher<Integer>, org.reactivestreams.Publisher<Integer>, Query, QueryPart, RowCountQuery, Serializable, Statement

All Known Subinterfaces:

AlterSequenceStep<T>

public interface AlterSequenceFlagsStep
extends AlterSequenceFinalStep

The step in the ALTER SEQUENCE statement where the flags of the sequence are modified or cleared.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

• They're operating on mutable implementations (as of jOOQ 3.x)
• They're less composable and not easy to get right when dynamic SQL gets complex
• They're less readable
• They might have binary incompatible changes between minor releases

Author:

Knut Wannheden

Method Summary

Modifier and Type	Method	Description
@NotNull AlterSequenceFlagsStep	cache(Number value)	Add a CACHE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	cache(Field<? extends Number> value)	Add a CACHE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	cycle()	Add a CYCLE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	incrementBy(Number value)	Add a INCREMENT BY clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	incrementBy(Field<? extends Number> value)	Add a INCREMENT BY clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	maxvalue(Number value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	maxvalue(Field<? extends Number> value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	minvalue(Number value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	minvalue(Field<? extends Number> value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	noCache()	Add a NO CACHE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	noCycle()	Add a NO CYCLE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	noMaxvalue()	Add a NO MINVALUE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	noMinvalue()	Add a NO MINVALUE clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	restart()	Restart the sequence at its initial value.
@NotNull AlterSequenceFlagsStep	restartWith(Number value)	Restart the sequence at a given value.
@NotNull AlterSequenceFlagsStep	restartWith(Field<? extends Number> value)	Restart the sequence at a given value.
@NotNull AlterSequenceFlagsStep	startWith(Number value)	Add a START WITH clause to the ALTER SEQUENCE statement.
@NotNull AlterSequenceFlagsStep	startWith(Field<? extends Number> value)	Add a START WITH clause to the ALTER SEQUENCE statement.

Methods inherited from interface org.jooq.Attachable

attach, configuration, detach

Methods inherited from interface java.util.concurrent.Flow.Publisher

subscribe

Methods inherited from interface org.reactivestreams.Publisher

subscribe

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, poolable, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

restart

@NotNull
@Support({AURORA_POSTGRES,DB2,HANA,HSQLDB,INFORMIX,MARIADB_10_3,POSTGRES,SQLSERVER2012,VERTICA})
@NotNull AlterSequenceFlagsStep restart()

Restart the sequence at its initial value.

restartWith

@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep restartWith(Number value)

Restart the sequence at a given value.

restartWith

@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep restartWith(Field<? extends Number> value)

Restart the sequence at a given value.

startWith

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,MARIADB_10_3,POSTGRES})
@NotNull AlterSequenceFlagsStep startWith(Number value)

Add a START WITH clause to the ALTER SEQUENCE statement.

startWith

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,MARIADB_10_3,POSTGRES})
@NotNull AlterSequenceFlagsStep startWith(Field<? extends Number> value)

Add a START WITH clause to the ALTER SEQUENCE statement.

incrementBy

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES_10,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep incrementBy(Number value)

Add a INCREMENT BY clause to the ALTER SEQUENCE statement.

incrementBy

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES_10,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep incrementBy(Field<? extends Number> value)

Add a INCREMENT BY clause to the ALTER SEQUENCE statement.

minvalue

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep minvalue(Number value)

Add a MINVALUE clause to the ALTER SEQUENCE statement.

minvalue

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep minvalue(Field<? extends Number> value)

Add a MINVALUE clause to the ALTER SEQUENCE statement.

noMinvalue

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep noMinvalue()

Add a NO MINVALUE clause to the ALTER SEQUENCE statement.

maxvalue

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep maxvalue(Number value)

Add a MINVALUE clause to the ALTER SEQUENCE statement.

maxvalue

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep maxvalue(Field<? extends Number> value)

Add a MINVALUE clause to the ALTER SEQUENCE statement.

noMaxvalue

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep noMaxvalue()

Add a NO MINVALUE clause to the ALTER SEQUENCE statement.

cycle

@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep cycle()

Add a CYCLE clause to the ALTER SEQUENCE statement.

noCycle

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep noCycle()

Add a NO CYCLE clause to the ALTER SEQUENCE statement.

cache

@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,H2,HANA,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep cache(Number value)

Add a CACHE clause to the ALTER SEQUENCE statement.

cache

@NotNull
@Support({AURORA_POSTGRES,CUBRID,DB2,H2,HANA,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep cache(Field<? extends Number> value)

Add a CACHE clause to the ALTER SEQUENCE statement.

noCache

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB_10_3,ORACLE,POSTGRES,SQLSERVER2012,SYBASE,VERTICA})
@NotNull AlterSequenceFlagsStep noCache()

Add a NO CACHE clause to the ALTER SEQUENCE statement.