Top Description Methods
org.jooq

public Interface AlterTableAlterStep<T>

Known Direct Implementers
org.jooq.impl.AlterTableImpl
Imports
org.jetbrains.annotations.*
The step in the ALTER TABLE DSL used to ALTER 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:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull AlterTableFinalStep
default_(T literal)

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Specify a new column DEFAULT.
public @NotNull AlterTableFinalStep
default_(Field<T> expression)

Deprecated as a consequence of Field and AlterTableFinalStep being deprecated.
Specify a new column DEFAULT.
public @NotNull AlterTableFinalStep
defaultValue(T literal)

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Specify a new column DEFAULT.
public @NotNull AlterTableFinalStep
defaultValue(Field<T> expression)

Deprecated as a consequence of Field and AlterTableFinalStep being deprecated.
Specify a new column DEFAULT.
public @NotNull AlterTableFinalStep
dropDefault()

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Drop the column DEFAULT.
public @NotNull AlterTableFinalStep
dropNotNull()

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Make the column nullable.
public @NotNull AlterTableFinalStep
set(DataType<?> type)

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Specify a new column data type.
public @NotNull AlterTableFinalStep
setDefault(T literal)

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Specify a new column DEFAULT.
public @NotNull AlterTableFinalStep
setDefault(Field<T> expression)

Deprecated as a consequence of Field and AlterTableFinalStep being deprecated.
Specify a new column DEFAULT.
public @NotNull AlterTableFinalStep
setNotNull()

Deprecated as a consequence of AlterTableFinalStep being deprecated.
Make the column NOT NULL.

Method Detail

default_back to summary
public @NotNull AlterTableFinalStep default_(T literal)

Deprecated

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

Specify a new column DEFAULT.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
default_back to summary
public @NotNull AlterTableFinalStep default_(Field<T> expression)

Deprecated

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

Specify a new column DEFAULT.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
defaultValueback to summary
public @NotNull AlterTableFinalStep defaultValue(T literal)

Deprecated

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

Specify a new column DEFAULT.

This is an alias for default_(Object).

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
defaultValueback to summary
public @NotNull AlterTableFinalStep defaultValue(Field<T> expression)

Deprecated

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

Specify a new column DEFAULT.

This is an alias for default_(Field).

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
dropDefaultback to summary
public @NotNull AlterTableFinalStep dropDefault()

Deprecated

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

Drop the column DEFAULT.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
dropNotNullback to summary
public @NotNull AlterTableFinalStep dropNotNull()

Deprecated

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

Make the column nullable.

Annotations
@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, YUGABYTEDB
setback to summary
public @NotNull AlterTableFinalStep set(DataType<?> type)

Deprecated

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

Specify a new column data type.

This adds or removes NOT NULL constraints on the column if DataType#nullable() is specified explicitly (not all databases support this).

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
setDefaultback to summary
public @NotNull AlterTableFinalStep setDefault(T literal)

Deprecated

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

Specify a new column DEFAULT.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
setDefaultback to summary
public @NotNull AlterTableFinalStep setDefault(Field<T> expression)

Deprecated

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

Specify a new column DEFAULT.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
setNotNullback to summary
public @NotNull AlterTableFinalStep setNotNull()

Deprecated

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

Make the column NOT NULL.

Annotations
@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES, YUGABYTEDB