Top Description Methods
org.jooq

public Interface CreateTableElementListStep

extends CreateTableAsStep
Known Direct Implementers
org.jooq.impl.CreateTableImpl
Annotations
@SuppressWarnings:unused
Static Imports
org.jooq.SQLDialect.*, org.jooq.impl.DSL.*

Deprecated

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

A step in the construction of the CREATE TABLE statement.

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:

Method Summary

Modifier and TypeMethod and Description
public @NotNull CreateTableElementListStep
check(Condition condition)

Deprecated as a consequence of Condition and CreateTableElementListStep being deprecated.
Add the CHECK clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
column(Field<?> column)

Deprecated as a consequence of Field and CreateTableElementListStep being deprecated.
Add the COLUMN clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
column(String field, DataType<?> type)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the COLUMN clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
column(Name field, DataType<?> type)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the COLUMN clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
column(Field<?> field, DataType<?> type)

Deprecated as a consequence of Field and CreateTableElementListStep being deprecated.
Add the COLUMN clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
columns(String... columns)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the COLUMNS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
columns(Name... columns)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the COLUMNS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
columns(Field<?>... columns)

Deprecated as a consequence of Field and CreateTableElementListStep being deprecated.
Add the COLUMNS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
columns(Collection<? extends Field<?>> columns)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the COLUMNS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
constraint(Constraint constraint)

Deprecated as a consequence of Constraint and CreateTableElementListStep being deprecated.
Add the CONSTRAINT clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
constraints(Constraint... constraints)

Deprecated as a consequence of Constraint and CreateTableElementListStep being deprecated.
Add the CONSTRAINTS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
constraints(Collection<? extends Constraint> constraints)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the CONSTRAINTS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
index(Index index)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the INDEX clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
indexes(Index... indexes)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the INDEXES clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
indexes(Collection<? extends Index> indexes)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the INDEXES clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
primaryKey(String... fields)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the PRIMARY KEY clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
primaryKey(Name... fields)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the PRIMARY KEY clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
primaryKey(Field<?>... fields)

Deprecated as a consequence of Field and CreateTableElementListStep being deprecated.
Add the PRIMARY KEY clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
primaryKey(Collection<? extends Field<?>> fields)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the PRIMARY KEY clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
tableElements(TableElement... tableElements)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the TABLE ELEMENTS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
tableElements(Collection<? extends TableElement> tableElements)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the TABLE ELEMENTS clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
unique(String... fields)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the UNIQUE clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
unique(Name... fields)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the UNIQUE clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
unique(Field<?>... fields)

Deprecated as a consequence of Field and CreateTableElementListStep being deprecated.
Add the UNIQUE clause to the CREATE TABLE statement.
public @NotNull CreateTableElementListStep
unique(Collection<? extends Field<?>> fields)

Deprecated as a consequence of CreateTableElementListStep being deprecated.
Add the UNIQUE clause to the CREATE TABLE statement.
Inherited from org.jooq.CreateTableAsStep:
as

Method Detail

checkback to summary
public @NotNull CreateTableElementListStep check(Condition condition)

Deprecated

as a consequence of Condition and CreateTableElementListStep being deprecated. See corresponding docs for further information.

Add the CHECK clause to the CREATE TABLE statement.

Annotations
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
@NotNull
@CheckReturnValue
columnback to summary
public @NotNull CreateTableElementListStep column(Field<?> column)

Deprecated

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

Add the COLUMN clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnback to summary
public @NotNull CreateTableElementListStep column(String field, DataType<?> type)

Deprecated

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

Add the COLUMN clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnback to summary
public @NotNull CreateTableElementListStep column(Name field, DataType<?> type)

Deprecated

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

Add the COLUMN clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnback to summary
public @NotNull CreateTableElementListStep column(Field<?> field, DataType<?> type)

Deprecated

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

Add the COLUMN clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnsback to summary
public @NotNull CreateTableElementListStep columns(String... columns)

Deprecated

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

Add the COLUMNS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnsback to summary
public @NotNull CreateTableElementListStep columns(Name... columns)

Deprecated

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

Add the COLUMNS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnsback to summary
public @NotNull CreateTableElementListStep columns(Field<?>... columns)

Deprecated

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

Add the COLUMNS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
columnsback to summary
public @NotNull CreateTableElementListStep columns(Collection<? extends Field<?>> columns)

Deprecated

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

Add the COLUMNS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
constraintback to summary
public @NotNull CreateTableElementListStep constraint(Constraint constraint)

Deprecated

as a consequence of Constraint and CreateTableElementListStep being deprecated. See corresponding docs for further information.

Add the CONSTRAINT clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
constraintsback to summary
public @NotNull CreateTableElementListStep constraints(Constraint... constraints)

Deprecated

as a consequence of Constraint and CreateTableElementListStep being deprecated. See corresponding docs for further information.

Add the CONSTRAINTS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
constraintsback to summary
public @NotNull CreateTableElementListStep constraints(Collection<? extends Constraint> constraints)

Deprecated

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

Add the CONSTRAINTS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
indexback to summary
public @NotNull CreateTableElementListStep index(Index index)

Deprecated

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

Add the INDEX clause to the CREATE TABLE statement.

Annotations
@Support:FIREBIRD, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
@NotNull
@CheckReturnValue
indexesback to summary
public @NotNull CreateTableElementListStep indexes(Index... indexes)

Deprecated

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

Add the INDEXES clause to the CREATE TABLE statement.

Annotations
@Support:FIREBIRD, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
@NotNull
@CheckReturnValue
indexesback to summary
public @NotNull CreateTableElementListStep indexes(Collection<? extends Index> indexes)

Deprecated

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

Add the INDEXES clause to the CREATE TABLE statement.

Annotations
@Support:FIREBIRD, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
@NotNull
@CheckReturnValue
primaryKeyback to summary
public @NotNull CreateTableElementListStep primaryKey(String... fields)

Deprecated

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

Add the PRIMARY KEY clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
primaryKeyback to summary
public @NotNull CreateTableElementListStep primaryKey(Name... fields)

Deprecated

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

Add the PRIMARY KEY clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
primaryKeyback to summary
public @NotNull CreateTableElementListStep primaryKey(Field<?>... fields)

Deprecated

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

Add the PRIMARY KEY clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
primaryKeyback to summary
public @NotNull CreateTableElementListStep primaryKey(Collection<? extends Field<?>> fields)

Deprecated

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

Add the PRIMARY KEY clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
tableElementsback to summary
public @NotNull CreateTableElementListStep tableElements(TableElement... tableElements)

Deprecated

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

Add the TABLE ELEMENTS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
tableElementsback to summary
public @NotNull CreateTableElementListStep tableElements(Collection<? extends TableElement> tableElements)

Deprecated

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

Add the TABLE ELEMENTS clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
uniqueback to summary
public @NotNull CreateTableElementListStep unique(String... fields)

Deprecated

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

Add the UNIQUE clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
uniqueback to summary
public @NotNull CreateTableElementListStep unique(Name... fields)

Deprecated

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

Add the UNIQUE clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
uniqueback to summary
public @NotNull CreateTableElementListStep unique(Field<?>... fields)

Deprecated

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

Add the UNIQUE clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue
uniqueback to summary
public @NotNull CreateTableElementListStep unique(Collection<? extends Field<?>> fields)

Deprecated

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

Add the UNIQUE clause to the CREATE TABLE statement.

Annotations
@Support
@NotNull
@CheckReturnValue