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
AlterSequenceFlagsStep	cache(Number value)	Add a CACHE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	cache(Field<? extends Number> value)	Add a CACHE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	cycle()	Add a CYCLE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	incrementBy(Number value)	Add a INCREMENT BY clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	incrementBy(Field<? extends Number> value)	Add a INCREMENT BY clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	maxvalue(Number value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	maxvalue(Field<? extends Number> value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	minvalue(Number value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	minvalue(Field<? extends Number> value)	Add a MINVALUE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	noCache()	Add a NO CACHE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	noCycle()	Add a NO CYCLE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	noMaxvalue()	Add a NO MINVALUE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	noMinvalue()	Add a NO MINVALUE clause to the ALTER SEQUENCE statement.
AlterSequenceFlagsStep	restart()	Restart the sequence at its initial value.
AlterSequenceFlagsStep	restartWith(Number value)	Restart the sequence at a given value.
AlterSequenceFlagsStep	restartWith(Field<? extends Number> value)	Restart the sequence at a given value.
AlterSequenceFlagsStep	startWith(Number value)	Add a START WITH clause to the ALTER SEQUENCE statement.
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

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

Restart the sequence at its initial value.

restartWith

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

Restart the sequence at a given value.

restartWith

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

Restart the sequence at a given value.

startWith

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

Add a START WITH clause to the ALTER SEQUENCE statement.

startWith

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

Add a START WITH clause to the ALTER SEQUENCE statement.

incrementBy

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

Add a INCREMENT BY clause to the ALTER SEQUENCE statement.

incrementBy

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

Add a INCREMENT BY clause to the ALTER SEQUENCE statement.

minvalue

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

Add a MINVALUE clause to the ALTER SEQUENCE statement.

minvalue

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

Add a MINVALUE clause to the ALTER SEQUENCE statement.

noMinvalue

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

Add a NO MINVALUE clause to the ALTER SEQUENCE statement.

maxvalue

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

Add a MINVALUE clause to the ALTER SEQUENCE statement.

maxvalue

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

Add a MINVALUE clause to the ALTER SEQUENCE statement.

noMaxvalue

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

Add a NO MINVALUE clause to the ALTER SEQUENCE statement.

cycle

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

Add a CYCLE clause to the ALTER SEQUENCE statement.

noCycle

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

Add a NO CYCLE clause to the ALTER SEQUENCE statement.

cache

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

Add a CACHE clause to the ALTER SEQUENCE statement.

cache

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

Add a CACHE clause to the ALTER SEQUENCE statement.

noCache

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

Add a NO CACHE clause to the ALTER SEQUENCE statement.