-
- All Superinterfaces:
AlterSequenceRestartStep<T>
public interface AlterSequenceStep<T extends Number> extends AlterSequenceRestartStep<T>
AQuery
that can alter sequences.Referencing
XYZ*Step
types directly from client codeIt 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:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description AlterSequenceFinalStep
renameTo(String newName)
Add aRENAME TO
clause to theALTER SEQUENCE
statement.AlterSequenceFinalStep
renameTo(Name newName)
Add aRENAME TO
clause to theALTER SEQUENCE
statement.AlterSequenceFinalStep
renameTo(Sequence<?> newName)
Add aRENAME TO
clause to theALTER SEQUENCE
statement.AlterSequenceFinalStep
restart()
Restart the sequence at its initial value.AlterSequenceFinalStep
restartWith(Field<? extends T> value)
Restart the sequence at a given value.AlterSequenceFinalStep
restartWith(T value)
Restart the sequence at a given value.
-
-
-
Method Detail
-
restart
@Support({AURORA_POSTGRES,DB2,HANA,HSQLDB,INFORMIX,POSTGRES,SQLSERVER2012,VERTICA}) AlterSequenceFinalStep restart()
Restart the sequence at its initial value.- Specified by:
restart
in interfaceAlterSequenceRestartStep<T extends Number>
-
restartWith
@Support({AURORA_POSTGRES,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) AlterSequenceFinalStep restartWith(T value)
Restart the sequence at a given value.- Specified by:
restartWith
in interfaceAlterSequenceRestartStep<T extends Number>
-
restartWith
@Support({AURORA_POSTGRES,CUBRID,DB2,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,POSTGRES,SQLSERVER2012,SYBASE,VERTICA}) AlterSequenceFinalStep restartWith(Field<? extends T> value)
Restart the sequence at a given value.- Specified by:
restartWith
in interfaceAlterSequenceRestartStep<T extends Number>
-
renameTo
@Support({AURORA_POSTGRES,HSQLDB,ORACLE,POSTGRES,VERTICA}) AlterSequenceFinalStep renameTo(Sequence<?> newName)
Add aRENAME TO
clause to theALTER SEQUENCE
statement.
-
renameTo
@Support({AURORA_POSTGRES,HSQLDB,ORACLE,POSTGRES,VERTICA}) AlterSequenceFinalStep renameTo(Name newName)
Add aRENAME TO
clause to theALTER SEQUENCE
statement.
-
renameTo
@Support({AURORA_POSTGRES,HSQLDB,ORACLE,POSTGRES,VERTICA}) AlterSequenceFinalStep renameTo(String newName)
Add aRENAME TO
clause to theALTER SEQUENCE
statement.
-
-