jOOQ 3.18.7 · org.jooq.AlterTableAddStep

The step in the ALTER TABLE DSL used to ADD columns.

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

Method Summary

Modifier and Type	Method and Description
public @NotNull AlterTableFinalStep	after(String columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. Add a `AFTER` clause to `ALTER TABLE … ADD …`.
public @NotNull AlterTableFinalStep	after(Name columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. Add a `AFTER` clause to `ALTER TABLE … ADD …`.
public @NotNull AlterTableFinalStep	after(Field<?> columnName) Deprecated as a consequence of `Field` and `AlterTableFinalStep` being deprecated. Add a `AFTER` clause to `ALTER TABLE … ADD …`.
public @NotNull AlterTableFinalStep	before(String columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. Add a `BEFORE` clause to `ALTER TABLE … ADD …`.
public @NotNull AlterTableFinalStep	before(Name columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. Add a `BEFORE` clause to `ALTER TABLE … ADD …`.
public @NotNull AlterTableFinalStep	before(Field<?> columnName) Deprecated as a consequence of `Field` and `AlterTableFinalStep` being deprecated. Add a `BEFORE` clause to `ALTER TABLE … ADD …`.
public @NotNull AlterTableFinalStep	first() Deprecated as a consequence of `AlterTableFinalStep` being deprecated. Add a `FIRST` clause to `ALTER TABLE … ADD …`.

Method Detail

after back to summary

after	back to summary
public @NotNull AlterTableFinalStep after(String columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `AFTER` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:H2, MARIADB, MYSQL

public @NotNull AlterTableFinalStep after(String columnName)

Deprecated

as a consequence of AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a AFTER clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:H2, MARIADB, MYSQL

after back to summary

after	back to summary
public @NotNull AlterTableFinalStep after(Name columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `AFTER` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:H2, MARIADB, MYSQL

public @NotNull AlterTableFinalStep after(Name columnName)

Deprecated

as a consequence of AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a AFTER clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:H2, MARIADB, MYSQL

after back to summary

after	back to summary
public @NotNull AlterTableFinalStep after(Field<?> columnName) Deprecated as a consequence of `Field` and `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `AFTER` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:H2, MARIADB, MYSQL

public @NotNull AlterTableFinalStep after(Field<?> columnName)

Deprecated

as a consequence of Field and AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a AFTER clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:H2, MARIADB, MYSQL

before back to summary

before	back to summary
public @NotNull AlterTableFinalStep before(String columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `BEFORE` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:H2, HSQLDB

public @NotNull AlterTableFinalStep before(String columnName)

Deprecated

as a consequence of AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a BEFORE clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:H2, HSQLDB

before back to summary

before	back to summary
public @NotNull AlterTableFinalStep before(Name columnName) Deprecated as a consequence of `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `BEFORE` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:H2, HSQLDB

public @NotNull AlterTableFinalStep before(Name columnName)

Deprecated

as a consequence of AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a BEFORE clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:H2, HSQLDB

before back to summary

before	back to summary
public @NotNull AlterTableFinalStep before(Field<?> columnName) Deprecated as a consequence of `Field` and `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `BEFORE` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:H2, HSQLDB

public @NotNull AlterTableFinalStep before(Field<?> columnName)

Deprecated

as a consequence of Field and AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a BEFORE clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:H2, HSQLDB

first back to summary

first	back to summary
public @NotNull AlterTableFinalStep first() Deprecated as a consequence of `AlterTableFinalStep` being deprecated. See corresponding docs for further information. Add a `FIRST` clause to `ALTER TABLE … ADD …`. Annotations @NotNull @CheckReturnValue @Support:FIREBIRD, H2, MARIADB, MYSQL

public @NotNull AlterTableFinalStep first()

Deprecated

as a consequence of AlterTableFinalStep being deprecated. See corresponding docs for further information.

Add a FIRST clause to ALTER TABLE … ADD ….

Annotations

@NotNull
@CheckReturnValue
@Support:FIREBIRD, H2, MARIADB, MYSQL

public Interface AlterTableAddStep

Referencing XYZ*Step types directly from client code

Method Summary

Method Detail

Referencing `XYZ*Step` types directly from client code