Uses of Interface org.jooq.Table (jOOQ 3.20.4-SNAPSHOT API)

Packages that use Table

Package

Description

org.jooq

This package contains jOOQ's public API.

org.jooq.impl

This package contains jOOQ's implementation classes.

org.jooq.util.postgres

This package contains classes related to the SQLDialect.POSTGRES dialect family.

Uses of Table in org.jooq

Classes in org.jooq with type parameters of type Table

Modifier and Type

Interface

Description

interface

Generator<R extends Record,X extends Table<R>,T>

A generator can be used with DataType.generatedAlwaysAs(Generator) to implement dynamic, client side computed columns, i.e.

interface

GeneratorContext<R extends Record,X extends Table<R>,T>

A GeneratorContext is an argument object that is passed to a Generator when generating client side computed columns.

Subinterfaces of Table in org.jooq

Modifier and Type

Interface

Description

interface

CommonTableExpression<R extends Record>

A common table expression.

interface

JSONTableColumnPathStep

A step in the construction of an JSON_TABLE expression.

interface

JSONTableColumnsStep

A step in the construction of an JSON_TABLE expression.

interface

TableOnConditionStep<R extends Record>

An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.

interface

TableOptionalOnStep<R extends Record>

An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)

interface

XMLTableColumnPathStep

A step in the construction of an XMLTABLE expression.

interface

XMLTableColumnsStep

A step in the construction of an XMLTABLE expression.

Methods in org.jooq that return Table

Modifier and Type

Method

Description

@Nullable Table<?>

Index.$table()

Experimental query object model accessor method, see also QOM.

@NotNull Table<?>

QualifiedAsterisk.$table()

Experimental query object model accessor method, see also QOM.

@NotNull Table<R>

VersionsBetweenAndStep.and(Field<? extends T> scn)

Add an AND clause to the flashback versions query clause.

@NotNull Table<R>

VersionsBetweenAndStep.and(T scn)

Add an AND clause to the flashback versions query clause.

@NotNull Table<R>

VersionsBetweenAndStep.andMaxvalue()

Add an AND MAXVALUE clause to the flashback versions query clause.

@NotNull Table<R>

Table.as(String alias)

Create an alias for this table.

@NotNull Table<R>

Table.as(String alias, String... fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(String alias, Collection<? extends String> fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(String alias, Function<? super Field<?>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Name alias)

Create an alias for this table.

@NotNull Table<R>

Table.as(Name alias, Collection<? extends Name> fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(Name alias, BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Name alias, Function<? super Field<?>,? extends Name> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Name alias, Name... fieldAliases)

Create an alias for this table and its fields.

@NotNull Table<R>

Table.as(Table<?> otherTable)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.as(Table<?> otherTable, Collection<? extends Field<?>> otherFields)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Table<?> otherTable, Field<?>... otherFields)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.asOfScn(Number scn)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

Table.asOfScn(Field<? extends Number> scn)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

Table.asOfTimestamp(Timestamp timestamp)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

Table.asOfTimestamp(Field<Timestamp> timestamp)

Create an SQLDialect.ORACLE flashback query clause from this table.

@NotNull Table<R>

TableLike.asTable()

The underlying table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias, String... fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias, Collection<? extends String> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

TableLike.asTable(String alias, Function<? super Field<?>,? extends String> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

TableLike.asTable(Name alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Name alias, Collection<? extends Name> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Name alias, Name... fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias, Field<?>... fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

Table.at(String link)

A table reference of this table at a given Link.

@NotNull Table<R>

Table.at(Link link)

A table reference of this table at a given Link.

@NotNull Table<R>

Table.at(Name link)

A table reference of this table at a given Link.

@NotNull Table<CHILD>

ForeignKey.children(Collection<? extends PARENT> records)

Get a table expression representing the children of a record, given this foreign key.

@NotNull Table<CHILD>

ForeignKey.children(PARENT record)

Get a table expression representing the children of a record, given this foreign key.

@NotNull Table<CHILD>

ForeignKey.children(PARENT... records)

Get a table expression representing the children of a record, given this foreign key.

<O extends TableRecord<O>> @NotNull Table<O>

Result.children(ForeignKey<O,R> key)

Get a table expression representing the children of all of this result's records, given a foreign key.

<O extends TableRecord<O>> @NotNull Table<O>

UpdatableRecord.children(ForeignKey<O,R> key)

Get a table expression representing the children of this record, given a foreign key.

@NotNull Table<Record>

Table.crossApply(String sql)

CROSS APPLY a table to this table.

@NotNull Table<Record>

Table.crossApply(String sql, Object... bindings)

CROSS APPLY a table to this table.

@NotNull Table<Record>

Table.crossApply(String sql, QueryPart... parts)

CROSS APPLY a table to this table.

@NotNull Table<Record>

Table.crossApply(Name name)

CROSS APPLY a table to this table.

@NotNull Table<Record>

Table.crossApply(SQL sql)

CROSS APPLY a table to this table.

@NotNull Table<Record>

Table.crossApply(TableLike<?> table)

CROSS APPLY a table to this table.

@NotNull Table<Record>

Table.crossJoin(String sql)

CROSS JOIN a table to this table.

@NotNull Table<Record>

Table.crossJoin(String sql, Object... bindings)

CROSS JOIN a table to this table.

@NotNull Table<Record>

Table.crossJoin(String sql, QueryPart... parts)

CROSS JOIN a table to this table.

@NotNull Table<Record>

Table.crossJoin(Name name)

CROSS JOIN a table to this table.

@NotNull Table<Record>

Table.crossJoin(SQL sql)

CROSS JOIN a table to this table.

@NotNull Table<Record>

Table.crossJoin(TableLike<?> table)

CROSS JOIN a table to this table.

@NotNull Table<R>

Table.for_(PeriodSpecification periodSpecification)

Create a reference to a temporal table with a PeriodSpecification for usage in Select.

@NotNull Table<R>

Table.forceIndex(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.forceIndexForGroupBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.forceIndexForJoin(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.forceIndexForOrderBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.forPortionOf(PeriodSpecification periodSpecification)

Create a reference to a temporal table with a PeriodSpecification for usage in Update and Delete.

Table<R>

Check.getTable()

The Key's owner table

@NotNull Table<R>

DAO.getTable()

Get the underlying table.

@NotNull Table<R>

Identity.getTable()

The IDENTITY's owner table

@Nullable Table<?>

Index.getTable()

The table on which this index is defined.

@NotNull Table<R>

Key.getTable()

The Key's owner table

@Nullable Table<?>

Schema.getTable(String name)

Get a table by its name (case-sensitive) in this schema, or null if no such table exists.

@Nullable Table<?>

Schema.getTable(Name name)

Get a table by its qualified or unqualified name in this schema, or null if no such table exists.

@Nullable Table<?>

Synonym.getTable()

The table being referenced by this synonym.

@Nullable Table<R>

TableField.getTable()

@NotNull Table<R>

TableRecord.getTable()

The table from which this record was read.

@Nullable Table<?>

Trigger.getTable()

The table of the trigger.

@NotNull Table<R>

Table.ignoreIndex(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.ignoreIndexForGroupBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.ignoreIndexForJoin(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.ignoreIndexForOrderBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<Record>

PivotInStep.in(Collection<? extends Field<T>> fields)

Specify the acceptable values for pivoting

@NotNull Table<Record>

PivotInStep.in(Field<?>... fields)

Specify the acceptable values for pivoting

@NotNull Table<Record>

PivotInStep.in(T... values)

Specify the acceptable values for pivoting

<R extends Record> @Nullable Table<R>

DSLContext.map(Table<R> table)

Map a table to another one.

<R extends Record> @Nullable Table<R>

SchemaMapping.map(Table<R> table)

Deprecated, for removal: This API element is subject to removal in a future version.

Apply mapping to a given table

@NotNull Table<Record>

Table.naturalFullOuterJoin(String sql)

NATURAL FULL OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalFullOuterJoin(String sql, Object... bindings)

NATURAL FULL OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalFullOuterJoin(String sql, QueryPart... parts)

NATURAL FULL OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalFullOuterJoin(Name name)

NATURAL FULL OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalFullOuterJoin(SQL sql)

NATURAL FULL OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalFullOuterJoin(TableLike<?> table)

NATURAL FULL OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalJoin(String sql)

NATURAL JOIN a table to this table.

@NotNull Table<Record>

Table.naturalJoin(String sql, Object... bindings)

NATURAL JOIN a table to this table.

@NotNull Table<Record>

Table.naturalJoin(String sql, QueryPart... parts)

NATURAL JOIN a table to this table.

@NotNull Table<Record>

Table.naturalJoin(Name name)

NATURAL JOIN a table to this table.

@NotNull Table<Record>

Table.naturalJoin(SQL sql)

NATURAL JOIN a table to this table.

@NotNull Table<Record>

Table.naturalJoin(TableLike<?> table)

NATURAL JOIN a table to this table.

@NotNull Table<Record>

Table.naturalLeftOuterJoin(String sql)

NATURAL LEFT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalLeftOuterJoin(String sql, Object... bindings)

NATURAL LEFT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalLeftOuterJoin(String sql, QueryPart... parts)

NATURAL LEFT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalLeftOuterJoin(Name name)

NATURAL LEFT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalLeftOuterJoin(SQL sql)

NATURAL LEFT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalLeftOuterJoin(TableLike<?> table)

NATURAL LEFT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalRightOuterJoin(String sql)

NATURAL RIGHT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalRightOuterJoin(String sql, Object... bindings)

NATURAL RIGHT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalRightOuterJoin(String sql, QueryPart... parts)

NATURAL RIGHT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalRightOuterJoin(Name name)

NATURAL RIGHT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalRightOuterJoin(SQL sql)

NATURAL RIGHT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.naturalRightOuterJoin(TableLike<?> table)

NATURAL RIGHT OUTER JOIN a table to this table.

@NotNull Table<Record>

Table.outerApply(String sql)

OUTER APPLY a table to this table.

@NotNull Table<Record>

Table.outerApply(String sql, Object... bindings)

OUTER APPLY a table to this table.

@NotNull Table<Record>

Table.outerApply(String sql, QueryPart... parts)

OUTER APPLY a table to this table.

@NotNull Table<Record>

Table.outerApply(Name name)

OUTER APPLY a table to this table.

@NotNull Table<Record>

Table.outerApply(SQL sql)

OUTER APPLY a table to this table.

@NotNull Table<Record>

Table.outerApply(TableLike<?> table)

OUTER APPLY a table to this table.

@NotNull Table<PARENT>

ForeignKey.parent(CHILD record)

Get a table expression representing the parent of a record, given this foreign key.

<O extends UpdatableRecord<O>> @NotNull Table<O>

TableRecord.parent(ForeignKey<R,O> key)

Get a table expression representing the parent of this record, given a foreign key.

@NotNull Table<PARENT>

ForeignKey.parents(CHILD... records)

Get a table expression representing the parents of a record, given this foreign key.

@NotNull Table<PARENT>

ForeignKey.parents(Collection<? extends CHILD> records)

Get a table expression representing the parents of a record, given this foreign key.

<O extends UpdatableRecord<O>> @NotNull Table<O>

Result.parents(ForeignKey<R,O> key)

Get a table expression representing the parents of all of this result's records, given a foreign key.

@NotNull Table<?>

ParseContext.parseTable()

Parse a Table expression or fail if the current expression is not a table.

default @Nullable Table<?>

ParseListener.parseTable(ParseContext ctx)

Attempt to parse a Table expression.

@NotNull Table<?>

Parser.parseTable(String sql)

Parse a SQL string into a Table.

@NotNull Table<?>

Parser.parseTable(String sql, Object... bindings)

Parse a SQL string with bind variables into a Table.

@NotNull Table<?>

QualifiedAsterisk.qualifier()

The qualifier.

@NotNull Table<Record>

DivideByReturningStep.returning(Collection<? extends Field<?>> fields)

Specify the fields that you want the division to return from the dividend

@NotNull Table<Record>

DivideByReturningStep.returning(Field<?>... fields)

Specify the fields that you want the division to return from the dividend

@NotNull Table<R>

Policy.table()

The table to apply the policy to.

@NotNull Table<R>

Table.useIndex(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.useIndexForGroupBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.useIndexForJoin(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<R>

Table.useIndexForOrderBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

@NotNull Table<Record>

TableOnStep.using(Collection<? extends Field<?>> fields)

Join a table with the USING(column [, column…]) syntax.

@NotNull Table<Record>

TableOnStep.using(Field<?>... fields)

Join a table with the USING(column [, column…]) syntax.

@NotNull Table<R>

Table.where(String sql)

Add a WHERE clause to the table.

@NotNull Table<R>

Table.where(String sql, Object... bindings)

Add a WHERE clause to the table.

@NotNull Table<R>

Table.where(String sql, QueryPart... parts)

Add a WHERE clause to the table.

@NotNull Table<R>

Table.where(Collection<? extends Condition> conditions)

Add a WHERE clause to the table, connecting them with each other with Operator.AND.

@NotNull Table<R>

Table.where(Condition condition)

Add a WHERE clause to the table, connecting them with each other with Operator.AND.

@NotNull Table<R>

Table.where(Condition... conditions)

Add a WHERE clause to the table, connecting them with each other with Operator.AND.

@NotNull Table<R>

Table.where(Field<Boolean> field)

Add a WHERE clause to the table.

@NotNull Table<R>

Table.where(SQL sql)

Add a WHERE clause to the table.

@NotNull Table<R>

Table.whereExists(Select<?> select)

Add a WHERE EXISTS clause to the table.

@NotNull Table<R>

Table.whereNotExists(Select<?> select)

Add a WHERE NOT EXISTS clause to the table.

@NotNull Table<R>

Table.with(String hint)

Specify a SQL Server style table hint for query optimisation.

@NotNull Table<R>

Table.with(String hint, Object... binds)

Specify a SQL Server style table hint for query optimisation.

@NotNull Table<R>

Table.with(String hint, QueryPart... parts)

Specify a SQL Server style table hint for query optimisation.

@NotNull Table<R>

Table.with(SQL hint)

Specify a SQL Server style table hint for query optimisation.

@NotNull Table<Record>

Table.withOrdinality()

Add the WITH ORDINALITY clause.

Methods in org.jooq that return types with arguments of type Table

Modifier and Type

Method

Description

@NotNull QOM.UnmodifiableList<? extends Table<?>>

Select.$from()

Experimental query object model accessor method, see also QOM.

@NotNull List<Table<?>>

Meta.getTables()

Get all table objects from the underlying meta data source.

@NotNull List<Table<?>>

Meta.getTables(String name)

Get all table objects by name from the underlying meta data source.

@NotNull List<Table<?>>

Meta.getTables(Name name)

Get all table objects by name from the underlying meta data source.

@NotNull List<Table<?>>

Schema.getTables()

List all tables contained in this schema.

@NotNull Stream<Table<?>>

Schema.tableStream()

Stream all tables contained in this schema.

Methods in org.jooq with parameters of type Table

Modifier and Type

Method

Description

void

SchemaMapping.add(Table<?> inputTable, String outputTable)

Deprecated, for removal: This API element is subject to removal in a future version.

Add tables to this mapping

void

SchemaMapping.add(Table<?> inputTable, Table<?> outputTable)

Deprecated, for removal: This API element is subject to removal in a future version.

Add tables to this mapping

@NotNull AlterViewStep

DSLContext.alterMaterializedView(Table<?> view)

The ALTER MATERIALIZED VIEW statement.

@NotNull AlterViewStep

DSLContext.alterMaterializedViewIfExists(Table<?> view)

The ALTER MATERIALIZED VIEW IF EXISTS statement.

@NotNull AlterTableStep

DSLContext.alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterTableStep

DSLContext.alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view, Collection<? extends Field<?>> fields)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterView(Table<?> view, Field<?>... fields)

The ALTER VIEW statement.

@NotNull AlterViewStep

DSLContext.alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

@NotNull Table<R>

Table.as(Table<?> otherTable)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.as(Table<?> otherTable, Collection<? extends Field<?>> otherFields)

Create an alias for this table based on another table's name.

@NotNull Table<R>

Table.as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull Table<R>

Table.as(Table<?> otherTable, Field<?>... otherFields)

Create an alias for this table based on another table's name.

@NotNull Table<R>

TableLike.asTable(Table<?> alias)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases)

The underlying aliased table representation of this object.

@NotNull Table<R>

TableLike.asTable(Table<?> alias, Field<?>... fieldAliases)

The underlying aliased table representation of this object.

<X extends Record> @NotNull CloseableResultQuery<X>

CloseableResultQuery.coerce(Table<X> table)

<X extends Record> @NotNull ResultQuery<X>

ResultQuery.coerce(Table<X> table)

Coerce the result record type of this query to that of a table.

@NotNull CommentOnIsStep

DSLContext.commentOnMaterializedView(Table<?> view)

The COMMENT ON MATERIALIZED VIEW statement.

@NotNull CommentOnIsStep

DSLContext.commentOnTable(Table<?> table)

The COMMENT ON TABLE statement.

@NotNull CommentOnIsStep

DSLContext.commentOnView(Table<?> view)

The COMMENT ON VIEW statement.

@NotNull CreateTableElementListStep

DSLContext.createGlobalTemporaryTable(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

DSLContext.createGlobalTemporaryTableIfNotExists(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createMaterializedView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE MATERIALIZED VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createMaterializedView(Table<?> view, Field<?>... fields)

The CREATE MATERIALIZED VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createMaterializedViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE MATERIALIZED VIEW IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createMaterializedViewIfNotExists(Table<?> view, Field<?>... fields)

The CREATE MATERIALIZED VIEW IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceMaterializedView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE OR REPLACE MATERIALIZED VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceMaterializedView(Table<?> view, Field<?>... fields)

The CREATE OR REPLACE MATERIALIZED VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE OR REPLACE VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

DSLContext.createOrReplaceView(Table<?> view, Field<?>... fields)

The CREATE OR REPLACE VIEW statement.

@NotNull CreateTableElementListStep

DSLContext.createTable(Table<?> table)

The CREATE TABLE statement.

@NotNull CreateTableElementListStep

DSLContext.createTableIfNotExists(Table<?> table)

The CREATE TABLE IF NOT EXISTS statement.

@NotNull CreateTableElementListStep

DSLContext.createTemporaryTable(Table<?> table)

The CREATE TEMPORARY TABLE statement.

@NotNull CreateTableElementListStep

DSLContext.createTemporaryTableIfNotExists(Table<?> table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

DSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

DSLContext.createView(Table<?> view, Field<?>... fields)

The CREATE VIEW statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE VIEW IF NOT EXISTS statement.

@NotNull CreateViewAsStep<Record>

DSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

DSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull CreateViewAsStep<Record>

DSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields)

The CREATE VIEW IF NOT EXISTS statement.

@NotNull Queries

DSLContext.ddl(Table<?> table)

Convenience method for Meta.ddl().

@NotNull Queries

DSLContext.ddl(Table<?>... tables)

Convenience method for Meta.ddl().

@NotNull Queries

DSLContext.ddl(Table<?>[] tables, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Table<?>[] tables, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Table<?> table, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Table<?> table, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

<R extends Record> @NotNull DeleteUsingStep<R>

DSLContext.delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record> @NotNull DeleteUsingStep<R>

WithStep.delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record> @NotNull DeleteUsingStep<R>

DSLContext.deleteFrom(Table<R> table)

Create a new DSL delete statement.

<R extends Record> @NotNull DeleteQuery<R>

DSLContext.deleteQuery(Table<R> table)

Create a new DeleteQuery

@NotNull DivideByOnStep

Table.divideBy(Table<?> divisor)

Create a new TABLE reference from this table, applying relational division.

@NotNull DropViewFinalStep

DSLContext.dropMaterializedView(Table<?> view)

The DROP MATERIALIZED VIEW statement.

@NotNull DropViewFinalStep

DSLContext.dropMaterializedViewIfExists(Table<?> view)

The DROP MATERIALIZED VIEW IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTable(Table<?> table)

The DROP TABLE statement.

@NotNull DropTableStep

DSLContext.dropTableIfExists(Table<?> table)

The DROP TABLE IF EXISTS statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTable(Table<?> table)

The DROP TEMPORARY TABLE statement.

@NotNull DropTableStep

DSLContext.dropTemporaryTableIfExists(Table<?> table)

The DROP TEMPORARY TABLE IF EXISTS statement.

@NotNull DropViewFinalStep

DSLContext.dropView(Table<?> view)

The DROP VIEW statement.

@NotNull DropViewFinalStep

DSLContext.dropViewIfExists(Table<?> view)

The DROP VIEW IF EXISTS statement.

@NotNull Condition

Table.eq(Table<R> arg2)

The EQ operator.

@NotNull Condition

Table.equal(Table<R> arg2)

The EQUAL operator, an alias for the EQ operator.

<R extends Record> @NotNull Result<R>

DSLContext.fetch(Table<R> table)

Execute and return all records for

<R extends Record> @NotNull Result<R>

DSLContext.fetch(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records for

<R extends Record> @NotNull Result<R>

DSLContext.fetch(Table<R> table, Condition condition)

Execute and return all records for

<R extends Record> @NotNull Result<R>

DSLContext.fetch(Table<R> table, Condition... conditions)

Execute and return all records for

<R extends Record> R

DSLContext.fetchAny(Table<R> table)

Execute and return zero or one record for

<R extends Record> R

DSLContext.fetchAny(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

<R extends Record> R

DSLContext.fetchAny(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record> R

DSLContext.fetchAny(Table<R> table, Condition... conditions)

Execute and return zero or on e record for

<Z extends Record> Z

ResultQuery.fetchAnyInto(Table<Z> table)

Map resulting records onto a custom record.

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Executor executor, Table<R> table)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Executor executor, Table<R> table, Condition condition)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Executor executor, Table<R> table, Condition... conditions)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Table<R> table)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Table<R> table, Collection<? extends Condition> condition)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Table<R> table, Condition condition)

Execute and return all records asynchronously for

<R extends Record> @NotNull CompletionStage<Result<R>>

DSLContext.fetchAsync(Table<R> table, Condition... condition)

Execute and return all records asynchronously for

int

DSLContext.fetchCount(Table<?> table)

Count the number of records in a table.

int

DSLContext.fetchCount(Table<?> table, Collection<? extends Condition> conditions)

Count the number of records in a table that satisfy a condition.

int

DSLContext.fetchCount(Table<?> table, Condition condition)

Count the number of records in a table that satisfy a condition.

int

DSLContext.fetchCount(Table<?> table, Condition... conditions)

Count the number of records in a table that satisfy a condition.

boolean

DSLContext.fetchExists(Table<?> table)

Check if a table has any records.

boolean

DSLContext.fetchExists(Table<?> table, Collection<? extends Condition> conditions)

Check if a table has any records that satisfy a condition.

boolean

DSLContext.fetchExists(Table<?> table, Condition condition)

Check if a table has any records that satisfy a condition.

boolean

DSLContext.fetchExists(Table<?> table, Condition... conditions)

Check if a table has any records that satisfy a condition.

<S extends Record> @NotNull Map<S,Result<R>>

ResultQuery.fetchGroups(Table<S> table)

Execute the query and return a Map with the result grouped by the given table.

<E, S extends Record> @NotNull Map<S,List<E>>

ResultQuery.fetchGroups(Table<S> table, Class<? extends E> type)

Execute the query and return a Map with results grouped by the given table and mapped into the given entity type.

<E, S extends Record> @NotNull Map<S,List<E>>

ResultQuery.fetchGroups(Table<S> table, RecordMapper<? super R,E> mapper)

Execute the query and return a Map with results grouped by the given table and mapped by the given mapper.

<S extends Record, T extends Record> @NotNull Map<S,Result<T>>

ResultQuery.fetchGroups(Table<S> keyTable, Table<T> valueTable)

Execute the query and return a Map with the result grouped by the given table.

<Z extends Record> @NotNull Result<Z>

Cursor.fetchInto(Table<Z> table)

Map resulting records onto a custom record.

<Z extends Record> @NotNull Result<Z>

ResultQuery.fetchInto(Table<Z> table)

Map resulting records onto a custom record.

<R extends Record> @NotNull Cursor<R>

DSLContext.fetchLazy(Table<R> table)

Execute and return all records lazily for

<R extends Record> @NotNull Cursor<R>

DSLContext.fetchLazy(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records lazily for

<R extends Record> @NotNull Cursor<R>

DSLContext.fetchLazy(Table<R> table, Condition condition)

Execute and return all records lazily for

<R extends Record> @NotNull Cursor<R>

DSLContext.fetchLazy(Table<R> table, Condition... conditions)

Execute and return all records lazily for

<S extends Record> @NotNull Map<S,R>

ResultQuery.fetchMap(Table<S> table)

Execute the query and return a Map with table as a map key and the corresponding record as value.

<E, S extends Record> @NotNull Map<S,E>

ResultQuery.fetchMap(Table<S> table, Class<? extends E> type)

Execute the query and return a Map with results grouped by the given table and mapped into the given entity type.

<E, S extends Record> @NotNull Map<S,E>

ResultQuery.fetchMap(Table<S> table, RecordMapper<? super R,E> mapper)

Execute the query and return a Map with results grouped by the given table and mapped by the given mapper.

<S extends Record, T extends Record> @NotNull Map<S,T>

ResultQuery.fetchMap(Table<S> keyTable, Table<T> valueTable)

Execute the query and return a Map with table as a map key and the corresponding record as value.

<Z extends Record> Z

Cursor.fetchNextInto(Table<Z> table)

Map the next resulting record onto a custom record.

<Z extends Record> @NotNull Optional<Z>

Cursor.fetchNextOptionalInto(Table<Z> table)

Map the next resulting record onto a custom record.

<R extends Record> R

DSLContext.fetchOne(Table<R> table)

Execute and return zero or one record for

<R extends Record> R

DSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

<R extends Record> R

DSLContext.fetchOne(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record> R

DSLContext.fetchOne(Table<R> table, Condition... conditions)

Execute and return zero or one record for

<Z extends Record> Z

Cursor.fetchOneInto(Table<Z> table)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.10 - [#6363] - Use Cursor.fetchNextInto(Table) instead.

<Z extends Record> Z

ResultQuery.fetchOneInto(Table<Z> table)

Map resulting records onto a custom record.

<R extends Record> @NotNull Optional<R>

DSLContext.fetchOptional(Table<R> table)

Execute and return zero or one record for

<R extends Record> @NotNull Optional<R>

DSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions)

Execute and return zero or one record for

<R extends Record> @NotNull Optional<R>

DSLContext.fetchOptional(Table<R> table, Condition condition)

Execute and return zero or one record for

<R extends Record> @NotNull Optional<R>

DSLContext.fetchOptional(Table<R> table, Condition... conditions)

Execute and return zero or one record for

<Z extends Record> @NotNull Optional<Z>

Cursor.fetchOptionalInto(Table<Z> table)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.10 - [#6363] - Use Cursor.fetchNextOptionalInto(Table) instead.

<Z extends Record> @NotNull Optional<Z>

ResultQuery.fetchOptionalInto(Table<Z> table)

Map resulting records onto a custom record.

<R extends Record> R

DSLContext.fetchSingle(Table<R> table)

Execute and return exactly one record for

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions)

Execute and return exactly one record for

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition condition)

Execute and return exactly one record for

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition... conditions)

Execute and return exactly one record for

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<Z extends Record> Z

ResultQuery.fetchSingleInto(Table<Z> table)

Map resulting records onto a custom record.

<R extends Record> @NotNull Stream<R>

DSLContext.fetchStream(Table<R> table)

Execute and return all records lazily for

<R extends Record> @NotNull Stream<R>

DSLContext.fetchStream(Table<R> table, Collection<? extends Condition> conditions)

Execute and return all records lazily for

<R extends Record> @NotNull Stream<R>

DSLContext.fetchStream(Table<R> table, Condition condition)

Execute and return all records lazily for

<R extends Record> @NotNull Stream<R>

DSLContext.fetchStream(Table<R> table, Condition... conditions)

Execute and return all records lazily for

<Z extends Record> @NotNull Stream<Z>

ResultQuery.fetchStreamInto(Table<Z> table)

Stream this query, mapping records into a custom record.

<T> T

DSLContext.fetchValue(Table<? extends Record1<T>> table)

Fetch a single value from a single column table.

<T> @NotNull List<T>

DSLContext.fetchValues(Table<? extends Record1<T>> table)

Fetch all values from a single column table.

@NotNull DDLQuery

CreateSynonymForStep.for_(Table<?> table)

Add the FOR clause to the CREATE SYNONYM statement.

void

Formattable.formatInsert(OutputStream stream, Table<?> table, Field<?>... fields)

Like Formattable.formatInsert(Table, Field...), but the data is output onto an OutputStream.

void

Formattable.formatInsert(Writer writer, Table<?> table, Field<?>... fields)

Like Formattable.formatInsert(Table, Field...), but the data is output onto an Writer.

@NotNull String

Formattable.formatInsert(Table<?> table, Field<?>... fields)

Get this result as a set of INSERT statements.

<O extends Record> @NotNull List<ForeignKey<O,R>>

Table.getReferencesFrom(Table<O> other)

Get a list of FOREIGN KEY's of a specific table, referencing a this table.

<O extends Record> @NotNull List<ForeignKey<R,O>>

Table.getReferencesTo(Table<O> other)

Get a list of FOREIGN KEY's of this table, referencing a specific table.

@NotNull InformationSchema

DSLContext.informationSchema(Table<?> table)

Convenience method for Meta.informationSchema().

@NotNull InformationSchema

DSLContext.informationSchema(Table<?>... table)

Convenience method for Meta.informationSchema().

<R extends Record> @NotNull InsertSetStep<R>

DSLContext.insertInto(Table<R> into)

Create a new DSL insert statement.

<R extends Record> @NotNull InsertValuesStepN<R>

DSLContext.insertInto(Table<R> into, Collection<? extends Field<?>> fields)

Create a new DSL insert statement.

<R extends Record> @NotNull InsertValuesStepN<R>

DSLContext.insertInto(Table<R> into, Field<?>... fields)

Create a new DSL insert statement.

<R extends Record, T1> @NotNull InsertValuesStep1<R,T1>

DSLContext.insertInto(Table<R> into, Field<T1> field1)

Create a new DSL insert statement.

<R extends Record, T1, T2> @NotNull InsertValuesStep2<R,T1,T2>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3> @NotNull InsertValuesStep3<R,T1,T2,T3>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4> @NotNull InsertValuesStep4<R,T1,T2,T3,T4>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5> @NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6> @NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

DSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Create a new DSL insert statement.

<R extends Record> @NotNull InsertSetStep<R>

WithStep.insertInto(Table<R> into)

Create a new DSL insert statement.

<R extends Record> @NotNull InsertValuesStepN<R>

WithStep.insertInto(Table<R> into, Collection<? extends Field<?>> fields)

Create a new DSL insert statement.

<R extends Record> @NotNull InsertValuesStepN<R>

WithStep.insertInto(Table<R> into, Field<?>... fields)

Create a new DSL insert statement.

<R extends Record, T1> @NotNull InsertValuesStep1<R,T1>

WithStep.insertInto(Table<R> into, Field<T1> field1)

Create a new DSL insert statement.

<R extends Record, T1, T2> @NotNull InsertValuesStep2<R,T1,T2>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3> @NotNull InsertValuesStep3<R,T1,T2,T3>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4> @NotNull InsertValuesStep4<R,T1,T2,T3,T4>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5> @NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6> @NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Create a new DSL insert statement.

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

WithStep.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Create a new DSL insert statement.

<R extends Record> @NotNull InsertQuery<R>

DSLContext.insertQuery(Table<R> into)

Create a new InsertQuery

<R extends Record> R

Record.into(Table<R> table)

Map resulting records onto a custom record type.

<Z extends Record> @NotNull Result<Z>

Result.into(Table<Z> table)

Map resulting records onto a custom record.

@NotNull SelectFromStep<Record>

SelectIntoStep.into(Table<?> table)

Add a T-SQL style INTO clause to the SELECT statement to create a new table from a SELECT statement.

<S extends Record> @NotNull Map<S,Result<R>>

Result.intoGroups(Table<S> table)

Return a Map with the result grouped by the given key table.

<E, S extends Record> @NotNull Map<S,List<E>>

Result.intoGroups(Table<S> table, Class<? extends E> type)

Return a Map with results grouped by the given key table and mapped into the given entity type.

<E, S extends Record> @NotNull Map<S,List<E>>

Result.intoGroups(Table<S> table, RecordMapper<? super R,E> mapper)

Return a Map with results grouped by the given key table and mapped into the given entity type.

<S extends Record, T extends Record> @NotNull Map<S,Result<T>>

Result.intoGroups(Table<S> keyTable, Table<T> valueTable)

Return a Map with the result grouped by the given key table.

<S extends Record> @NotNull Map<S,R>

Result.intoMap(Table<S> table)

Return a Map with the given key table as a map key and the corresponding record as value.

<E, S extends Record> @NotNull Map<S,E>

Result.intoMap(Table<S> table, Class<? extends E> type)

Return a Map with results grouped by the given key table and mapped into the given entity type.

<E, S extends Record> @NotNull Map<S,E>

Result.intoMap(Table<S> table, RecordMapper<? super R,E> mapper)

Return a Map with results grouped by the given key table and mapped by the given mapper.

<S extends Record, T extends Record> @NotNull Map<S,T>

Result.intoMap(Table<S> keyTable, Table<T> valueTable)

Return a Map with the given key table as a map key and the corresponding record as value.

<R extends Record> @NotNull LoaderOptionsStep<R>

DSLContext.loadInto(Table<R> table)

Create a new Loader object to load data from a CSV or XML source.

<R extends Record> @Nullable Table<R>

DSLContext.map(Table<R> table)

Map a table to another one.

<R extends Record> @Nullable Table<R>

SchemaMapping.map(Table<R> table)

Deprecated, for removal: This API element is subject to removal in a future version.

Apply mapping to a given table

static final @NotNull Replacer

Replacers.mappingTable(Table<?> input, Table<?> output)

A Replacer that maps a pair of tables similar to the functionality offered by Settings.getRenderMapping().

<R extends Record> @NotNull MergeUsingStep<R>

DSLContext.mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

<R extends Record> @NotNull MergeKeyStepN<R>

DSLContext.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record> @NotNull MergeKeyStepN<R>

DSLContext.mergeInto(Table<R> table, Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1> @NotNull MergeKeyStep1<R,T1>

DSLContext.mergeInto(Table<R> table, Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2> @NotNull MergeKeyStep2<R,T1,T2>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3> @NotNull MergeKeyStep3<R,T1,T2,T3>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5> @NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6> @NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

<R extends Record> @NotNull MergeUsingStep<R>

WithStep.mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

<R extends Record> @NotNull MergeKeyStepN<R>

WithStep.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

Create a new DSL merge statement (H2-specific syntax).

<R extends Record> @NotNull MergeKeyStepN<R>

WithStep.mergeInto(Table<R> table, Field<?>... fields)

Create a new DSL merge statement (H2-specific syntax).

<R extends Record, T1> @NotNull MergeKeyStep1<R,T1>

WithStep.mergeInto(Table<R> table, Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2> @NotNull MergeKeyStep2<R,T1,T2>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3> @NotNull MergeKeyStep3<R,T1,T2,T3>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5> @NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6> @NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

WithStep.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via WithStep.mergeInto(Table)

@NotNull Meta

DSLContext.meta(Table<?>... tables)

Access the database meta data from explicit table information.

@NotNull Condition

Table.ne(Table<R> arg2)

The NE operator.

<R extends Record> R

DSLContext.newRecord(Table<R> table)

Create a new Record that can be inserted into the corresponding table.

<R extends Record> R

DSLContext.newRecord(Table<R> table, Object source)

Create a new pre-filled Record that can be inserted into the corresponding table.

<R extends Record> @NotNull Result<R>

DSLContext.newResult(Table<R> table)

Create a new empty Result.

@NotNull Condition

Table.notEqual(Table<R> arg2)

The NOT_EQUAL operator, an alias for the NE operator.

@NotNull SelectForUpdateWaitStep<R>

SelectForUpdateOfStep.of(Table<?>... tables)

Add an OF clause to the FOR <lock_mode> clause at the end of the query.

@NotNull AlterIndexStep

AlterIndexOnStep.on(Table<?> on)

Add the ON clause to the ALTER INDEX statement.

@NotNull CreateIndexIncludeStep

CreateIndexStep.on(Table<?> table, Collection<? extends OrderField<?>> on)

Add the ON clause to the CREATE INDEX statement.

@NotNull CreateIndexIncludeStep

CreateIndexStep.on(Table<?> table, OrderField<?>... on)

Add the ON clause to the CREATE INDEX statement.

@NotNull CreateTriggerReferencingStep

CreateTriggerEventOnStep.on(Table<?> on)

Add the ON clause to the CREATE TRIGGER statement.

@NotNull DropIndexCascadeStep

DropIndexOnStep.on(Table<?> on)

Add the ON clause to the DROP INDEX statement.

@NotNull DDLQuery

DropTriggerOnStep.on(Table<?> on)

Add the ON clause to the DROP TRIGGER statement.

@NotNull GrantToStep

GrantOnStep.on(Table<?> on)

Add the ON clause to the GRANT statement.

@NotNull RevokeFromStep

RevokeOnStep.on(Table<?> on)

Add the ON clause to the REVOKE statement.

<R extends Record> @NotNull List<Policy<R>>

PolicyProvider.provide(Table<R> table)

Provide a list of Policy for a table's row level security.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep1.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep1.references(Table<?> table, Field<T1> field1)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep10.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep10.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep11.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep11.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep12.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep12.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep13.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep13.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep14.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep14.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep15.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep15.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep16.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep16.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep17.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep17.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep18.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep18.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep19.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep19.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep2.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep2.references(Table<?> table, Field<T1> field1, Field<T2> field2)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep20.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep20.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep21.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep21.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep22.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep22.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep3.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep3.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep4.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep4.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep5.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep5.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep6.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep6.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep7.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep7.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep8.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep8.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep9.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStep9.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStepN.references(Table<?> table)

Add a REFERENCES clause to the CONSTRAINT, implicitly referencing the primary key.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStepN.references(Table<?> table, Collection<? extends Field<?>> fields)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull ConstraintForeignKeyOnStep

ConstraintForeignKeyReferencesStepN.references(Table<?> table, Field<?>... fields)

Add a REFERENCES clause to the CONSTRAINT, referencing a key by column names.

@NotNull AlterTableFinalStep

AlterTableStep.renameTo(Table<?> newName)

Add a RENAME TO clause to the ALTER TABLE statement.

@NotNull AlterViewFinalStep

AlterViewStep.renameTo(Table<?> renameTo)

Add the RENAME TO clause to the ALTER VIEW statement.

void

SelectQuery.setForLockModeOf(Table<?>... tables)

Some RDBMS allow for specifying the tables that should be locked by the FOR <lock_mode> clause, instead of the full row.

void

SelectQuery.setForUpdateOf(Table<?>... tables)

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use SelectQuery.setForLockModeOf(Table...)

void

SelectQuery.setInto(Table<?> table)

Add a T-SQL style INTO clause to the SELECT statement to create a new table from a SELECT statement.

@NotNull TruncateIdentityStep<Record>

DSLContext.truncate(Table<?>... table)

The TRUNCATE statement.

<R extends Record> @NotNull TruncateIdentityStep<R>

DSLContext.truncate(Table<R> table)

The TRUNCATE statement.

@NotNull TruncateIdentityStep<Record>

DSLContext.truncateTable(Table<?>... table)

The TRUNCATE TABLE statement.

<R extends Record> @NotNull TruncateIdentityStep<R>

DSLContext.truncateTable(Table<R> table)

The TRUNCATE TABLE statement.

<R extends Record> @NotNull UpdateSetFirstStep<R>

DSLContext.update(Table<R> table)

Create a new DSL update statement.

<R extends Record> @NotNull UpdateSetFirstStep<R>

WithStep.update(Table<R> table)

Create a new DSL update statement.

<R extends Record> @NotNull UpdateQuery<R>

DSLContext.updateQuery(Table<R> table)

Create a new UpdateQuery

Method parameters in org.jooq with type arguments of type Table

Modifier and Type

Method

Description

@NotNull Select<R>

Select.$from(Collection<? extends Table<?>> newFrom)

Experimental query object model accessor method, see also QOM.

@NotNull Queries

DSLContext.ddl(Collection<? extends Table<?>> tables)

Convenience method for Meta.ddl().

@NotNull Queries

DSLContext.ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Queries

DSLContext.ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)

Convenience method for Meta.ddl(DDLExportConfiguration).

@NotNull Meta

Meta.filterTables(Predicate<? super Table<?>> filter)

Create a wrapper Meta instance filtering out some tables.

static final @NotNull Replacer

Replacers.mappingTable(Function<? super Table<?>,? extends Table<?>> replacement)

A Replacer that maps tables similar to the functionality offered by Settings.getRenderMapping().

static final @NotNull Replacer

Replacers.mappingTable(Function<? super Table<?>,? extends Table<?>> replacement)

A Replacer that maps tables similar to the functionality offered by Settings.getRenderMapping().

static CallbackParseListener

ParseListener.onParseTable(Function<? super ParseContext,? extends Table<?>> onParseTable)

Create a ParseListener with a ParseListener.parseTable(ParseContext) implementation.

@NotNull TruncateIdentityStep<Record>

DSLContext.truncate(Collection<? extends Table<?>> table)

The TRUNCATE statement.

@NotNull TruncateIdentityStep<Record>

DSLContext.truncateTable(Collection<? extends Table<?>> table)

The TRUNCATE TABLE statement.
Uses of Table in org.jooq.impl

Classes in org.jooq.impl with type parameters of type Table

Modifier and Type

Class

Description

final class

AuditGenerator<R extends Record,X extends Table<R>,T>

A Generator that can be used for audit columns, whose values are defined by Configuration.auditProvider().

Subinterfaces of Table in org.jooq.impl

Modifier and Type

Interface

Description

static interface

QOM.CrossApply<R extends Record>

static interface

QOM.CrossJoin<R extends Record>

static interface

QOM.DataChangeDeltaTable<R extends Record>

static interface

QOM.DerivedTable<R extends Record>

static interface

QOM.Dual

static interface

QOM.FullJoin<R extends Record>

static interface

QOM.GenerateSeries<T>

static interface

QOM.HintedTable<R extends Record>

A table with a MySQL style index access hint.

static interface

QOM.Join<R extends Record>

static interface

QOM.JoinTable<R extends Record,J extends QOM.JoinTable<R,J>>

static interface

QOM.Lateral<R extends Record>

static interface

QOM.LeftAntiJoin<R extends Record>

static interface

QOM.LeftJoin<R extends Record>

static interface

QOM.LeftSemiJoin<R extends Record>

static interface

QOM.LinkedTable<R extends Record>

A table with a database link.

static interface

QOM.NaturalFullJoin<R extends Record>

static interface

QOM.NaturalJoin<R extends Record>

static interface

QOM.NaturalLeftJoin<R extends Record>

static interface

QOM.NaturalRightJoin<R extends Record>

static interface

QOM.OuterApply<R extends Record>

static interface

QOM.QualifiedJoin<R extends Record,J extends QOM.QualifiedJoin<R,J>>

static interface

QOM.RightJoin<R extends Record>

static interface

QOM.RowsFrom

static interface

QOM.StraightJoin<R extends Record>

static interface

QOM.TableAlias<R extends Record>

static interface

QOM.Values<R extends Record>

static interface

QOM.WithOrdinalityTable<R extends Record>

A collection derived table or table valued function with a WITH ORDINALITY clause.

static interface

QOM.WithTable<R extends Record>

A table with a T-SQL style WITH hint.

Classes in org.jooq.impl that implement Table

Modifier and Type

Class

Description

class

CustomTable<R extends TableRecord<R>>

A base class for custom Table implementations in client code.

class

TableImpl<R extends Record>

A common base type for tables

Methods in org.jooq.impl with type parameters of type Table

Modifier and Type

Method

Description

static final <R extends Record, TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Binding<T,U> binding, Generator<R,TR,U> generator)

static final <R extends Record, TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Converter<T,U> converter, Generator<R,TR,U> generator)

static final <R extends Record, TR extends Table<R>, T, X, U, P extends UDTPathTableField<R, ?, U>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Converter<X,U> converter, Binding<T,X> binding, Generator<R,TR,U> generator)

static final <R extends Record, TR extends Table<R>, T, P extends UDTPathTableField<R, ?, T>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Generator<R,TR,T> generator)

Methods in org.jooq.impl that return Table

Modifier and Type

Method

Description

default @NotNull Table<R>

QOM.TableAlias.$aliased()

final Table<R>

TableImpl.$aliased()

@NotNull Table<R>

QOM.Delete.$from()

@NotNull Table<R>

QOM.Insert.$into()

@NotNull Table<R>

QOM.Merge.$into()

@Nullable Table<?>

QOM.AlterIndex.$on()

@NotNull Table<?>

QOM.CreateTrigger.$on()

@Nullable Table<?>

QOM.DropIndex.$on()

@Nullable Table<?>

QOM.DropTrigger.$on()

@NotNull Table<?>

QOM.Grant.$on()

@NotNull Table<?>

QOM.Revoke.$on()

@NotNull Table<?>

QOM.ForeignKey.$referencesTable()

@Nullable Table<?>

QOM.AlterView.$renameTo()

@Nullable Table<?>

QOM.CommentOn.$table()

@NotNull Table<?>

QOM.CountTable.$table()

@Nullable Table<?>

QOM.CreateIndex.$table()

@NotNull Table<?>

QOM.CreateSynonym.$table()

@NotNull Table<?>

QOM.CreateTable.$table()

@NotNull Table<?>

QOM.DropTable.$table()

@NotNull Table<R>

QOM.HintedTable.$table()

@NotNull Table<R>

QOM.LinkedTable.$table()

default @NotNull Table<?>

QOM.QualifiedRowid.$table()

@NotNull Table<R>

QOM.TableAlias.$table()

@NotNull Table<R>

QOM.TableAsField.$table()

@NotNull Table<R>

QOM.Update.$table()

@NotNull Table<?>

QOM.WithOrdinalityTable.$table()

@NotNull Table<R>

QOM.WithTable.$table()

@NotNull Table<?>

QOM.JoinTable.$table1()

@NotNull Table<?>

QOM.JoinTable.$table2()

@NotNull Table<?>

QOM.AlterView.$view()

@NotNull Table<?>

QOM.CreateView.$view()

@NotNull Table<?>

QOM.DropView.$view()

Table<R>

TableImpl.as(Name as)

Subclasses may override this method to provide custom aliasing implementations

Table<R>

TableImpl.as(Name as, Name... fieldAliases)

Subclasses may override this method to provide custom aliasing implementations

final <O extends TableRecord<O>> Table<O>

UpdatableRecordImpl.children(ForeignKey<O,R> key)

static @NotNull Table<Record>

DSL.dual()

The DUAL table to be used for syntactic completeness.

static <R extends Record> @NotNull Table<R>

DSL.finalTable(Insert<R> query)

Get the data change delta table with result option NEW to retrieve the modified data from after the Update or Insert statement was applied.

static <R extends Record> @NotNull Table<R>

DSL.finalTable(Merge<R> query)

Get the data change delta table with result option NEW to retrieve the modified data from after the Update or Insert statement was applied.

static <R extends Record> @NotNull Table<R>

DSL.finalTable(Update<R> query)

Get the data change delta table with result option NEW to retrieve the modified data from after the Update or Insert statement was applied.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(int from, int to)

A table function generating a series of values from from to to (inclusive).

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(int from, int to, int step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(int from, int to, Field<Integer> step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(int from, Field<Integer> to)

A table function generating a series of values from from to to (inclusive).

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(int from, Field<Integer> to, int step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(int from, Field<Integer> to, Field<Integer> step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(Field<Integer> from, int to)

A table function generating a series of values from from to to (inclusive).

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(Field<Integer> from, int to, int step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(Field<Integer> from, int to, Field<Integer> step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(Field<Integer> from, Field<Integer> to)

A table function generating a series of values from from to to (inclusive).

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(Field<Integer> from, Field<Integer> to, int step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

static @NotNull Table<Record1<Integer>>

DSL.generateSeries(Field<Integer> from, Field<Integer> to, Field<Integer> step)

A table function generating a series of values from from to to (inclusive), increasing values by step.

Table<R>

DAOImpl.getTable()

final Table<?>

LazySchema.getTable(String name)

final Table<?>

LazySchema.getTable(Name name)

final Table<?>

SchemaImpl.getTable(String name)

final Table<?>

SchemaImpl.getTable(Name name)

final Table<R>

TableRecordImpl.getTable()

final Table<R>

UDTPathTableFieldImpl.getTable()

static <R extends Record> @NotNull Table<R>

DSL.lateral(TableLike<R> table)

Create a LATERAL joined table.

<R extends Record> Table<R>

DefaultDSLContext.map(Table<R> table)

static <R extends Record> @NotNull Table<R>

DSL.newTable(Insert<R> query)

Get the data change delta table with result option NEW to retrieve the modified data from after the Update or Insert statement was applied.

static <R extends Record> @NotNull Table<R>

DSL.newTable(Merge<R> query)

Get the data change delta table with result option NEW to retrieve the modified data from after the Update or Insert statement was applied.

static <R extends Record> @NotNull Table<R>

DSL.newTable(Update<R> query)

Get the data change delta table with result option NEW to retrieve the modified data from after the Update or Insert statement was applied.

static @NotNull Table<?>

DSL.noTable()

Return a Table that behaves like no table being present.

static <R extends Record> @NotNull Table<R>

DSL.oldTable(Delete<R> query)

Get the data change delta table with result option OLD to retrieve the modified data from before the Update or Delete statement was applied.

static <R extends Record> @NotNull Table<R>

DSL.oldTable(Merge<R> query)

Get the data change delta table with result option OLD to retrieve the modified data from before the Update or Delete statement was applied.

static <R extends Record> @NotNull Table<R>

DSL.oldTable(Update<R> query)

Get the data change delta table with result option OLD to retrieve the modified data from before the Update or Delete statement was applied.

final <O extends UpdatableRecord<O>> Table<O>

TableRecordImpl.parent(ForeignKey<R,O> key)

final Table<?>

CallbackParseListener.parseTable(ParseContext ctx)

Table<R>

TableImpl.rename(String rename)

Table<R>

TableImpl.rename(Name rename)

Table<R>

TableImpl.rename(Table<?> rename)

static @NotNull Table<Record>

DSL.rowsFrom(Table<?>... tables)

Create a ROWS FROM (tables…) expression.

static @NotNull Table<?>

DSL.table(Object[] array)

A synonym for DSL.unnest(Object[]).

static @NotNull Table<Record>

DSL.table(String sql)

A custom SQL clause that can render arbitrary table expressions.

static @NotNull Table<Record>

DSL.table(String sql, Object... bindings)

A custom SQL clause that can render arbitrary table expressions.

static @NotNull Table<Record>

DSL.table(String sql, QueryPart... parts)

A custom SQL clause that can render arbitrary table expressions.

static @NotNull Table<?>

DSL.table(Collection<?> list)

A synonym for DSL.unnest(Collection).

static @NotNull Table<?>

DSL.table(ArrayRecord<?> array)

A synonym for DSL.unnest(ArrayRecord).

static @NotNull Table<?>

DSL.table(Field<?> cursor)

A synonym for DSL.unnest(Field).

static @NotNull Table<Record>

DSL.table(Name name)

Create a qualified table, given its table name.

static @NotNull Table<Record>

DSL.table(Name name, Comment comment)

Create a qualified table, given its table name.

static <R extends Record> @NotNull Table<R>

DSL.table(Result<R> result)

Use a previously obtained result as a new Table that can be used in SQL statements through DSL.values(RowN...).

static <R extends Record> @NotNull Table<R>

DSL.table(Select<R> select)

A synonym for TableLike.asTable(), which might look a bit more fluent like this, to some users.

static @NotNull Table<Record>

DSL.table(SQL sql)

A custom SQL clause that can render arbitrary table expressions.

static <R extends Record> @NotNull Table<R>

DSL.table(R record)

Use a previously obtained record as a new Table

static <R extends Record> @NotNull Table<R>

DSL.table(R... records)

Use a previously obtained set of records as a new Table

static @NotNull Table<?>

DSL.unnest(Object[] array)

Create a table from an array of values.

static @NotNull Table<?>

DSL.unnest(Collection<?> list)

Create a table from a list of values.

static @NotNull Table<?>

DSL.unnest(ArrayRecord<?> array)

Create a table from an array of values.

static @NotNull Table<?>

DSL.unnest(Field<?> cursor)

Create a table from a field.

static <T1> @NotNull Table<Record1<T1>>

DSL.values(Row1<T1>... rows)

Create a VALUES() expression of degree 1.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Table<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

DSL.values(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)

Create a VALUES() expression of degree 10.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull Table<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>

DSL.values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... rows)

Create a VALUES() expression of degree 11.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull Table<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>

DSL.values(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... rows)

Create a VALUES() expression of degree 12.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull Table<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>

DSL.values(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... rows)

Create a VALUES() expression of degree 13.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull Table<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>

DSL.values(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>... rows)

Create a VALUES() expression of degree 14.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull Table<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>

DSL.values(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>... rows)

Create a VALUES() expression of degree 15.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull Table<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>

DSL.values(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows)

Create a VALUES() expression of degree 16.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull Table<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>

DSL.values(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>... rows)

Create a VALUES() expression of degree 17.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull Table<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>

DSL.values(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)

Create a VALUES() expression of degree 18.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull Table<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>

DSL.values(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)

Create a VALUES() expression of degree 19.

static <T1, T2> @NotNull Table<Record2<T1,T2>>

DSL.values(Row2<T1,T2>... rows)

Create a VALUES() expression of degree 2.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull Table<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>

DSL.values(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>... rows)

Create a VALUES() expression of degree 20.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull Table<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>

DSL.values(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>... rows)

Create a VALUES() expression of degree 21.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull Table<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>

DSL.values(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>... rows)

Create a VALUES() expression of degree 22.

static <T1, T2, T3> @NotNull Table<Record3<T1,T2,T3>>

DSL.values(Row3<T1,T2,T3>... rows)

Create a VALUES() expression of degree 3.

static <T1, T2, T3, T4> @NotNull Table<Record4<T1,T2,T3,T4>>

DSL.values(Row4<T1,T2,T3,T4>... rows)

Create a VALUES() expression of degree 4.

static <T1, T2, T3, T4, T5> @NotNull Table<Record5<T1,T2,T3,T4,T5>>

DSL.values(Row5<T1,T2,T3,T4,T5>... rows)

Create a VALUES() expression of degree 5.

static <T1, T2, T3, T4, T5, T6> @NotNull Table<Record6<T1,T2,T3,T4,T5,T6>>

DSL.values(Row6<T1,T2,T3,T4,T5,T6>... rows)

Create a VALUES() expression of degree 6.

static <T1, T2, T3, T4, T5, T6, T7> @NotNull Table<Record7<T1,T2,T3,T4,T5,T6,T7>>

DSL.values(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)

Create a VALUES() expression of degree 7.

static <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Table<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>

DSL.values(Row8<T1,T2,T3,T4,T5,T6,T7,T8>... rows)

Create a VALUES() expression of degree 8.

static <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Table<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>

DSL.values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows)

Create a VALUES() expression of degree 9.

static @NotNull Table<Record>

DSL.values(RowN... rows)

Create a VALUES() expression of arbitrary degree.

Methods in org.jooq.impl that return types with arguments of type Table

Modifier and Type

Method

Description

@NotNull QOM.UnmodifiableList<? extends Table<?>>

QOM.Update.$from()

@NotNull QOM.UnmodifiableList<? extends Table<?>>

QOM.Truncate.$table()

@NotNull QOM.UnmodifiableList<? extends Table<?>>

QOM.RowsFrom.$tables()

@NotNull QOM.UnmodifiableList<? extends Table<?>>

QOM.Delete.$using()

final List<Table<?>>

LazySchema.getTables()

List<Table<?>>

SchemaImpl.getTables()

List all tables contained in this schema.

final Stream<Table<?>>

LazySchema.tableStream()

final Stream<Table<?>>

SchemaImpl.tableStream()

Methods in org.jooq.impl with parameters of type Table

Modifier and Type

Method

Description

@NotNull QOM.Delete<?>

QOM.Delete.$from(Table<?> table)

@NotNull QOM.Insert<?>

QOM.Insert.$into(Table<?> into)

@NotNull QOM.Merge<?>

QOM.Merge.$into(Table<?> into)

@NotNull QOM.AlterIndex

QOM.AlterIndex.$on(Table<?> on)

@NotNull QOM.CreateTrigger

QOM.CreateTrigger.$on(Table<?> on)

@NotNull QOM.DropIndex

QOM.DropIndex.$on(Table<?> on)

@NotNull QOM.DropTrigger

QOM.DropTrigger.$on(Table<?> on)

@NotNull QOM.Grant

QOM.Grant.$on(Table<?> on)

@NotNull QOM.Revoke

QOM.Revoke.$on(Table<?> on)

@NotNull QOM.ForeignKey

QOM.ForeignKey.$referencesTable(Table<?> newReferencesTable)

@NotNull QOM.AlterView

QOM.AlterView.$renameTo(Table<?> renameTo)

@NotNull QOM.CommentOn

QOM.CommentOn.$table(Table<?> table)

@NotNull QOM.CreateIndex

QOM.CreateIndex.$table(Table<?> table)

@NotNull QOM.CreateSynonym

QOM.CreateSynonym.$table(Table<?> table)

@NotNull QOM.CreateTable

QOM.CreateTable.$table(Table<?> table)

@NotNull QOM.DropTable

QOM.DropTable.$table(Table<?> table)

<O extends Record> @NotNull QOM.HintedTable<O>

QOM.HintedTable.$table(Table<O> newTable)

<O extends Record> @NotNull QOM.LinkedTable<O>

QOM.LinkedTable.$table(Table<O> newTable)

default @NotNull QOM.QualifiedRowid

QOM.QualifiedRowid.$table(Table<?> newTable)

@NotNull QOM.Update<?>

QOM.Update.$table(Table<?> table)

@NotNull QOM.WithOrdinalityTable<?>

QOM.WithOrdinalityTable.$table(Table<?> newTable)

<O extends Record> @NotNull QOM.WithTable<O>

QOM.WithTable.$table(Table<O> newTable)

J

QOM.JoinTable.$table1(Table<?> table1)

J

QOM.JoinTable.$table2(Table<?> table2)

@NotNull QOM.AlterView

QOM.AlterView.$view(Table<?> view)

@NotNull QOM.CreateView<R>

QOM.CreateView.$view(Table<?> view)

@NotNull QOM.DropView

QOM.DropView.$view(Table<?> view)

AlterViewStep

DefaultDSLContext.alterMaterializedView(Table<?> view)

static AlterViewStep

DSL.alterMaterializedView(Table<?> view)

The ALTER MATERIALIZED VIEW statement.

AlterViewStep

DefaultDSLContext.alterMaterializedViewIfExists(Table<?> view)

static AlterViewStep

DSL.alterMaterializedViewIfExists(Table<?> view)

The ALTER MATERIALIZED VIEW IF EXISTS statement.

AlterTableStep

DefaultDSLContext.alterTable(Table<?> table)

static @NotNull AlterTableStep

DSL.alterTable(Table<?> table)

Create a new DSL ALTER TABLE statement.

AlterTableStep

DefaultDSLContext.alterTableIfExists(Table<?> table)

static @NotNull AlterTableStep

DSL.alterTableIfExists(Table<?> table)

Create a new DSL ALTER TABLE statement.

AlterViewStep

DefaultDSLContext.alterView(Table<?> view)

AlterViewStep

DefaultDSLContext.alterView(Table<?> view, Collection<? extends Field<?>> fields)

AlterViewStep

DefaultDSLContext.alterView(Table<?> view, Field<?>... fields)

static AlterViewStep

DSL.alterView(Table<?> view)

The ALTER VIEW statement.

static AlterViewStep

DSL.alterView(Table<?> view, Collection<? extends Field<?>> fields)

The ALTER VIEW statement.

static AlterViewStep

DSL.alterView(Table<?> view, Field<?>... fields)

The ALTER VIEW statement.

AlterViewStep

DefaultDSLContext.alterViewIfExists(Table<?> view)

static AlterViewStep

DSL.alterViewIfExists(Table<?> view)

The ALTER VIEW IF EXISTS statement.

final DefaultPolicyProvider

DefaultPolicyProvider.append(Table<?> table, Condition condition)

Add a Policy for a Policy.table() and Policy.condition().

final <R extends Record> DefaultPolicyProvider

DefaultPolicyProvider.append(Table<R> table, Condition condition, Collection<? extends Path<R>> inherited)

Add a Policy for a Policy.table() and Policy.condition() as well as a set of Policy.inherited() paths.

final <R extends Record> DefaultPolicyProvider

DefaultPolicyProvider.append(Table<R> table, Condition condition, Path<R>... inherited)

Add a Policy for a Policy.table() and Policy.condition() as well as a set of Policy.inherited() paths.

CommentOnIsStep

DefaultDSLContext.commentOnMaterializedView(Table<?> view)

static CommentOnIsStep

DSL.commentOnMaterializedView(Table<?> view)

The COMMENT ON MATERIALIZED VIEW statement.

CommentOnIsStep

DefaultDSLContext.commentOnTable(Table<?> table)

static CommentOnIsStep

DSL.commentOnTable(Table<?> table)

The COMMENT ON TABLE statement.

CommentOnIsStep

DefaultDSLContext.commentOnView(Table<?> view)

static CommentOnIsStep

DSL.commentOnView(Table<?> view)

The COMMENT ON VIEW statement.

static @NotNull AggregateFunction<Integer>

DSL.count(Table<?> table)

Get the count(table) function.

static @NotNull AggregateFunction<Integer>

DSL.countDistinct(Table<?> table)

Get the count(distinct table) function.

static final <R extends Record> @NotNull Check<R>

Internal.createCheck(Table<R> table, Name name, String condition)

Factory method for check constraints.

static final <R extends Record> @NotNull Check<R>

Internal.createCheck(Table<R> table, Name name, String condition, boolean enforced)

Factory method for check constraints.

static final <R extends Record, E extends EmbeddableRecord<E>> @NotNull TableField<R,E>

Internal.createEmbeddable(Name name, Class<E> recordType, boolean replacesFields, Table<R> table, TableField<R,?>... fields)

Factory method for embeddable types.

static final <R extends Record, E extends EmbeddableRecord<E>> @NotNull TableField<R,E>

Internal.createEmbeddable(Name name, Class<E> recordType, Table<R> table, TableField<R,?>... fields)

Factory method for embeddable types.

static <R extends Record, U extends Record> ForeignKey<R,U>

AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)

Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code

static <R extends Record, U extends Record> ForeignKey<R,U>

AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)

Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code

static final <R extends Record, U extends Record> @NotNull ForeignKey<R,U>

Internal.createForeignKey(Table<R> table, Name name, TableField<R,?>[] fkFields, UniqueKey<U> uk, TableField<U,?>[] ukFields, boolean enforced)

Deprecated.
- 3.20.0 - [#9736] - Regenerate your code.

static final <R extends Record, U extends Record> @NotNull ForeignKey<R,U>

Internal.createForeignKey(Table<R> table, Name name, TableField<R,?>[] fkFields, UniqueKey<U> uk, TableField<U,?>[] ukFields, boolean enforced, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule)

Factory method for foreign keys.

static final <R extends Record, U extends Record, ER extends EmbeddableRecord<ER>> @NotNull ForeignKey<R,U>

Internal.createForeignKey(Table<R> table, Name name, TableField<R,ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U,ER> ukEmbeddableField, boolean enforced)

Deprecated.
- 3.20.0 - [#9736] - Regenerate your code.

static final <R extends Record, U extends Record, ER extends EmbeddableRecord<ER>> @NotNull ForeignKey<R,U>

Internal.createForeignKey(Table<R> table, Name name, TableField<R,ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U,ER> ukEmbeddableField, boolean enforced, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule)

Factory method for foreign keys.

static final <R extends Record, U extends Record> @NotNull ForeignKey<R,U>

Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#9404] - Please re-generate your code.

static final <R extends Record, U extends Record> @NotNull ForeignKey<R,U>

Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#9404] - Please re-generate your code.

static final <R extends Record, U extends Record> @NotNull ForeignKey<R,U>

Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule)

Factory method for foreign keys.

static final <R extends Record, U extends Record> @NotNull ForeignKey<R,U>

Internal.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)

Deprecated.
- 3.14.0 - [#9404] - Please re-generate your code.

CreateTableElementListStep

DefaultDSLContext.createGlobalTemporaryTable(Table<?> table)

static CreateTableElementListStep

DSL.createGlobalTemporaryTable(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE statement.

CreateTableElementListStep

DefaultDSLContext.createGlobalTemporaryTableIfNotExists(Table<?> table)

static CreateTableElementListStep

DSL.createGlobalTemporaryTableIfNotExists(Table<?> table)

The CREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS statement.

static <R extends Record, T> Identity<R,T>

AbstractKeys.createIdentity(Table<R> table, TableField<R,T> field)

Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code

static final <R extends Record, T> @NotNull Identity<R,T>

Internal.createIdentity(Table<R> table, TableField<R,T> field)

Factory method for identities.

static Index

AbstractKeys.createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)

Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code

static final @NotNull Index

Internal.createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#9404] - Please re-generate your code.

static final @NotNull Index

Internal.createIndex(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique)

Factory method for indexes.

CreateViewAsStep<Record>

DefaultDSLContext.createMaterializedView(Table<?> view, Collection<? extends Field<?>> fields)

CreateViewAsStep<Record>

DefaultDSLContext.createMaterializedView(Table<?> view, Field<?>... fields)

static CreateViewAsStep<Record>

DSL.createMaterializedView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE MATERIALIZED VIEW statement.

static CreateViewAsStep<Record>

DSL.createMaterializedView(Table<?> view, Field<?>... fields)

The CREATE MATERIALIZED VIEW statement.

CreateViewAsStep<Record>

DefaultDSLContext.createMaterializedViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields)

CreateViewAsStep<Record>

DefaultDSLContext.createMaterializedViewIfNotExists(Table<?> view, Field<?>... fields)

static CreateViewAsStep<Record>

DSL.createMaterializedViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE MATERIALIZED VIEW IF NOT EXISTS statement.

static CreateViewAsStep<Record>

DSL.createMaterializedViewIfNotExists(Table<?> view, Field<?>... fields)

The CREATE MATERIALIZED VIEW IF NOT EXISTS statement.

CreateViewAsStep<Record>

DefaultDSLContext.createOrReplaceMaterializedView(Table<?> view, Collection<? extends Field<?>> fields)

CreateViewAsStep<Record>

DefaultDSLContext.createOrReplaceMaterializedView(Table<?> view, Field<?>... fields)

static CreateViewAsStep<Record>

DSL.createOrReplaceMaterializedView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE OR REPLACE MATERIALIZED VIEW statement.

static CreateViewAsStep<Record>

DSL.createOrReplaceMaterializedView(Table<?> view, Field<?>... fields)

The CREATE OR REPLACE MATERIALIZED VIEW statement.

CreateViewAsStep<Record>

DefaultDSLContext.createOrReplaceView(Table<?> view, Collection<? extends Field<?>> fields)

CreateViewAsStep<Record>

DefaultDSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

CreateViewAsStep<Record>

DefaultDSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

CreateViewAsStep<Record>

DefaultDSLContext.createOrReplaceView(Table<?> view, Field<?>... fields)

static CreateViewAsStep<Record>

DSL.createOrReplaceView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE OR REPLACE VIEW statement.

static @NotNull CreateViewAsStep<Record>

DSL.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

static CreateViewAsStep<Record>

DSL.createOrReplaceView(Table<?> view, Field<?>... fields)

The CREATE OR REPLACE VIEW statement.

static final @NotNull Name

Internal.createPathAlias(Table<?> path, ForeignKey<?,?> childPath, InverseForeignKey<?,?> parentPath)

Factory method for path aliases.

static final @NotNull Synonym

Internal.createSynonym(Schema schema, Name name, Table<?> table, boolean isPublic, Comment comment)

Factory method for synonym specifications.

CreateTableElementListStep

DefaultDSLContext.createTable(Table<?> table)

static CreateTableElementListStep

DSL.createTable(Table<?> table)

The CREATE TABLE statement.

CreateTableElementListStep

DefaultDSLContext.createTableIfNotExists(Table<?> table)

static CreateTableElementListStep

DSL.createTableIfNotExists(Table<?> table)

The CREATE TABLE IF NOT EXISTS statement.

CreateTableElementListStep

DefaultDSLContext.createTemporaryTable(Table<?> table)

static CreateTableElementListStep

DSL.createTemporaryTable(Table<?> table)

The CREATE TEMPORARY TABLE statement.

CreateTableElementListStep

DefaultDSLContext.createTemporaryTableIfNotExists(Table<?> table)

static CreateTableElementListStep

DSL.createTemporaryTableIfNotExists(Table<?> table)

The CREATE TEMPORARY TABLE IF NOT EXISTS statement.

static final @NotNull Trigger

Internal.createTrigger(Schema schema, Table<?> table, List<Field<?>> fields, Name name, Comment comment, TriggerTime time, Set<TriggerEvent> events, TriggerExecution execution, Condition when, int actionOrder, Statement action)

Factory method for trigger specifications.

static final <R extends Record, T, P extends UDTPathTableField<R, ?, T>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, Class<P> returnType)

static final <R extends Record, T, P extends UDTPathTableField<R, ?, T>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType)

static final <R extends Record, T, U, P extends UDTPathTableField<R, ?, U>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Binding<T,U> binding)

static final <R extends Record, T, U, P extends UDTPathTableField<R, ?, U>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Converter<T,U> converter)

static final <R extends Record, T, X, U, P extends UDTPathTableField<R, ?, U>> P

Internal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Converter<X,U> converter, Binding<T,X> binding)

static <R extends Record> UniqueKey<R>

AbstractKeys.createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)

Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code

static <R extends Record> UniqueKey<R>

AbstractKeys.createUniqueKey(Table<R> table, TableField<R,?>... fields)

Deprecated.
- [#6875] [#7158] - 3.11.0 - Please re-generate your code

static final <R extends Record> @NotNull UniqueKey<R>

Internal.createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#9404] - Please re-generate your code.

static final <R extends Record> @NotNull UniqueKey<R>

Internal.createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#9404] - Please re-generate your code.

static final <R extends Record> @NotNull UniqueKey<R>

Internal.createUniqueKey(Table<R> table, Name name, TableField<R,?>... fields)

Factory method for unique keys.

static final <R extends Record> @NotNull UniqueKey<R>

Internal.createUniqueKey(Table<R> table, Name name, TableField<R,?>[] fields, boolean enforced)

Factory method for unique keys.

static final <R extends Record, ER extends EmbeddableRecord<ER>> @NotNull UniqueKey<R>

Internal.createUniqueKey(Table<R> table, Name name, TableField<R,ER> embeddableField, boolean enforced)

Factory method for unique keys.

static final <R extends Record> @NotNull UniqueKey<R>

Internal.createUniqueKey(Table<R> table, TableField<R,?>... fields)

Factory method for unique keys.

CreateViewAsStep<Record>

DefaultDSLContext.createView(Table<?> view, Collection<? extends Field<?>> fields)

CreateViewAsStep<Record>

DefaultDSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

CreateViewAsStep<Record>

DefaultDSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

CreateViewAsStep<Record>

DefaultDSLContext.createView(Table<?> view, Field<?>... fields)

static CreateViewAsStep<Record>

DSL.createView(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE VIEW statement.

static @NotNull CreateViewAsStep<Record>

DSL.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

static CreateViewAsStep<Record>

DSL.createView(Table<?> view, Field<?>... fields)

The CREATE VIEW statement.

CreateViewAsStep<Record>

DefaultDSLContext.createViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields)

CreateViewAsStep<Record>

DefaultDSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)

CreateViewAsStep<Record>

DefaultDSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

CreateViewAsStep<Record>

DefaultDSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields)

static CreateViewAsStep<Record>

DSL.createViewIfNotExists(Table<?> view, Collection<? extends Field<?>> fields)

The CREATE VIEW IF NOT EXISTS statement.

static @NotNull CreateViewAsStep<Record>

DSL.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

static CreateViewAsStep<Record>

DSL.createViewIfNotExists(Table<?> view, Field<?>... fields)

The CREATE VIEW IF NOT EXISTS statement.

Queries

DefaultDSLContext.ddl(Table... tables)

Queries

DefaultDSLContext.ddl(Table[] tables, DDLExportConfiguration exportConfiguration)

Queries

DefaultDSLContext.ddl(Table[] tables, DDLFlag... flags)

Queries

DefaultDSLContext.ddl(Table<?> table)

Queries

DefaultDSLContext.ddl(Table<?> table, DDLExportConfiguration exportConfiguration)

Queries

DefaultDSLContext.ddl(Table<?> table, DDLFlag... flags)

<R extends Record> DeleteUsingStep<R>

DefaultDSLContext.delete(Table<R> table)

static <R extends Record> @NotNull DeleteUsingStep<R>

DSL.delete(Table<R> table)

Create a new DSL delete statement.

<R extends Record> DeleteUsingStep<R>

DefaultDSLContext.deleteFrom(Table<R> table)

static <R extends Record> @NotNull DeleteUsingStep<R>

DSL.deleteFrom(Table<R> table)

Create a new DSL delete statement.

<R extends Record> DeleteQuery<R>

DefaultDSLContext.deleteQuery(Table<R> table)

DropViewFinalStep

DefaultDSLContext.dropMaterializedView(Table<?> view)

static DropViewFinalStep

DSL.dropMaterializedView(Table<?> view)

The DROP MATERIALIZED VIEW statement.

DropViewFinalStep

DefaultDSLContext.dropMaterializedViewIfExists(Table<?> view)

static DropViewFinalStep

DSL.dropMaterializedViewIfExists(Table<?> view)

The DROP MATERIALIZED VIEW IF EXISTS statement.

DropTableStep

DefaultDSLContext.dropTable(Table<?> table)

static DropTableStep

DSL.dropTable(Table<?> table)

The DROP TABLE statement.

DropTableStep

DefaultDSLContext.dropTableIfExists(Table<?> table)

static DropTableStep

DSL.dropTableIfExists(Table<?> table)

The DROP TABLE IF EXISTS statement.

DropTableStep

DefaultDSLContext.dropTemporaryTable(Table<?> table)

static DropTableStep

DSL.dropTemporaryTable(Table<?> table)

The DROP TEMPORARY TABLE statement.

DropTableStep

DefaultDSLContext.dropTemporaryTableIfExists(Table<?> table)

static DropTableStep

DSL.dropTemporaryTableIfExists(Table<?> table)

The DROP TEMPORARY TABLE IF EXISTS statement.

DropViewFinalStep

DefaultDSLContext.dropView(Table<?> view)

static DropViewFinalStep

DSL.dropView(Table<?> view)

The DROP VIEW statement.

DropViewFinalStep

DefaultDSLContext.dropViewIfExists(Table<?> view)

static DropViewFinalStep

DSL.dropViewIfExists(Table<?> view)

The DROP VIEW IF EXISTS statement.

<R extends Record> Result<R>

DefaultDSLContext.fetch(Table<R> table)

<R extends Record> Result<R>

DefaultDSLContext.fetch(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> Result<R>

DefaultDSLContext.fetch(Table<R> table, Condition condition)

<R extends Record> Result<R>

DefaultDSLContext.fetch(Table<R> table, Condition... conditions)

<R extends Record> R

DefaultDSLContext.fetchAny(Table<R> table)

<R extends Record> R

DefaultDSLContext.fetchAny(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> R

DefaultDSLContext.fetchAny(Table<R> table, Condition condition)

<R extends Record> R

DefaultDSLContext.fetchAny(Table<R> table, Condition... conditions)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Executor executor, Table<R> table)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Executor executor, Table<R> table, Condition condition)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Executor executor, Table<R> table, Condition... conditions)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Table<R> table)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Table<R> table, Condition condition)

<R extends Record> CompletionStage<Result<R>>

DefaultDSLContext.fetchAsync(Table<R> table, Condition... conditions)

int

DefaultDSLContext.fetchCount(Table<?> table)

int

DefaultDSLContext.fetchCount(Table<?> table, Collection<? extends Condition> conditions)

int

DefaultDSLContext.fetchCount(Table<?> table, Condition condition)

int

DefaultDSLContext.fetchCount(Table<?> table, Condition... conditions)

boolean

DefaultDSLContext.fetchExists(Table<?> table)

boolean

DefaultDSLContext.fetchExists(Table<?> table, Collection<? extends Condition> conditions)

boolean

DefaultDSLContext.fetchExists(Table<?> table, Condition condition)

boolean

DefaultDSLContext.fetchExists(Table<?> table, Condition... conditions)

<R extends Record> Cursor<R>

DefaultDSLContext.fetchLazy(Table<R> table)

<R extends Record> Cursor<R>

DefaultDSLContext.fetchLazy(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> Cursor<R>

DefaultDSLContext.fetchLazy(Table<R> table, Condition condition)

<R extends Record> Cursor<R>

DefaultDSLContext.fetchLazy(Table<R> table, Condition... conditions)

<R extends Record> R

DefaultDSLContext.fetchOne(Table<R> table)

<R extends Record> R

DefaultDSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> R

DefaultDSLContext.fetchOne(Table<R> table, Condition condition)

<R extends Record> R

DefaultDSLContext.fetchOne(Table<R> table, Condition... conditions)

<R extends Record> Optional<R>

DefaultDSLContext.fetchOptional(Table<R> table)

<R extends Record> Optional<R>

DefaultDSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> Optional<R>

DefaultDSLContext.fetchOptional(Table<R> table, Condition condition)

<R extends Record> Optional<R>

DefaultDSLContext.fetchOptional(Table<R> table, Condition... conditions)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition condition)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition... conditions)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21)

<R extends Record> R

DefaultDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22)

<R extends Record> Stream<R>

DefaultDSLContext.fetchStream(Table<R> table)

<R extends Record> Stream<R>

DefaultDSLContext.fetchStream(Table<R> table, Collection<? extends Condition> conditions)

<R extends Record> Stream<R>

DefaultDSLContext.fetchStream(Table<R> table, Condition condition)

<R extends Record> Stream<R>

DefaultDSLContext.fetchStream(Table<R> table, Condition... conditions)

<T> T

DefaultDSLContext.fetchValue(Table<? extends Record1<T>> table)

<T> List<T>

DefaultDSLContext.fetchValues(Table<? extends Record1<T>> table)

final void

ArrayRecordImpl.formatInsert(Writer writer, Table<?> table, Field<?>... fields)

final void

AssociativeArrayRecordImpl.formatInsert(Writer writer, Table<?> table, Field<?>... fields)

InformationSchema

DefaultDSLContext.informationSchema(Table<?> table)

InformationSchema

DefaultDSLContext.informationSchema(Table<?>... tables)

<R extends Record> InsertSetStep<R>

DefaultDSLContext.insertInto(Table<R> into)

<R extends Record> InsertValuesStepN<R>

DefaultDSLContext.insertInto(Table<R> into, Collection<? extends Field<?>> fields)

<R extends Record> InsertValuesStepN<R>

DefaultDSLContext.insertInto(Table<R> into, Field<?>... fields)

<R extends Record, T1> InsertValuesStep1<R,T1>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1)

<R extends Record, T1, T2> InsertValuesStep2<R,T1,T2>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

<R extends Record, T1, T2, T3> InsertValuesStep3<R,T1,T2,T3>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)

<R extends Record, T1, T2, T3, T4> InsertValuesStep4<R,T1,T2,T3,T4>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

<R extends Record, T1, T2, T3, T4, T5> InsertValuesStep5<R,T1,T2,T3,T4,T5>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

<R extends Record, T1, T2, T3, T4, T5, T6> InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

<R extends Record, T1, T2, T3, T4, T5, T6, T7> InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

DefaultDSLContext.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

static <R extends Record> @NotNull InsertSetStep<R>

DSL.insertInto(Table<R> into)

Create a new DSL insert statement.

static <R extends Record> @NotNull InsertValuesStepN<R>

DSL.insertInto(Table<R> into, Collection<? extends Field<?>> fields)

Create a new DSL insert statement.

static <R extends Record> @NotNull InsertValuesStepN<R>

DSL.insertInto(Table<R> into, Field<?>... fields)

Create a new DSL insert statement.

static <R extends Record, T1> @NotNull InsertValuesStep1<R,T1>

DSL.insertInto(Table<R> into, Field<T1> field1)

Create a new DSL insert statement.

static <R extends Record, T1, T2> @NotNull InsertValuesStep2<R,T1,T2>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3> @NotNull InsertValuesStep3<R,T1,T2,T3>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4> @NotNull InsertValuesStep4<R,T1,T2,T3,T4>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5> @NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6> @NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Create a new DSL insert statement.

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

DSL.insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Create a new DSL insert statement.

<R extends Record> InsertQuery<R>

DefaultDSLContext.insertQuery(Table<R> into)

<R extends Record> LoaderOptionsStep<R>

DefaultDSLContext.loadInto(Table<R> table)

<R extends Record> Table<R>

DefaultDSLContext.map(Table<R> table)

<R extends Record> MergeUsingStep<R>

DefaultDSLContext.mergeInto(Table<R> table)

<R extends Record> MergeKeyStepN<R>

DefaultDSLContext.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record> MergeKeyStepN<R>

DefaultDSLContext.mergeInto(Table<R> table, Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1> MergeKeyStep1<R,T1>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2> MergeKeyStep2<R,T1,T2>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3> MergeKeyStep3<R,T1,T2,T3>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4> MergeKeyStep4<R,T1,T2,T3,T4>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5> MergeKeyStep5<R,T1,T2,T3,T4,T5>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6> MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7> MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

DefaultDSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DefaultDSLContext.mergeInto(Table)

static <R extends Record> @NotNull MergeUsingStep<R>

DSL.mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

static <R extends Record> @NotNull MergeKeyStepN<R>

DSL.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record> @NotNull MergeKeyStepN<R>

DSL.mergeInto(Table<R> table, Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1> @NotNull MergeKeyStep1<R,T1>

DSL.mergeInto(Table<R> table, Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2> @NotNull MergeKeyStep2<R,T1,T2>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3> @NotNull MergeKeyStep3<R,T1,T2,T3>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5> @NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6> @NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

static <R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>

DSL.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)

Meta

DefaultDSLContext.meta(Table<?>... tables)

<R extends Record> R

DefaultDSLContext.newRecord(Table<R> table)

<R extends Record> R

DefaultDSLContext.newRecord(Table<R> table, Object source)

<R extends Record> Result<R>

DefaultDSLContext.newResult(Table<R> table)

<R extends Record> List<Policy<R>>

DefaultPolicyProvider.provide(Table<R> table)

Table<R>

TableImpl.rename(Table<?> rename)

static @NotNull Table<Record>

DSL.rowsFrom(Table<?>... tables)

Create a ROWS FROM (tables…) expression.

TruncateIdentityStep<Record>

DefaultDSLContext.truncate(Table<?>... table)

<R extends Record> TruncateIdentityStep<R>

DefaultDSLContext.truncate(Table<R> table)

static TruncateIdentityStep<Record>

DSL.truncate(Table<?>... table)

The TRUNCATE statement.

static <R extends Record> TruncateIdentityStep<R>

DSL.truncate(Table<R> table)

The TRUNCATE statement.

TruncateIdentityStep<Record>

DefaultDSLContext.truncateTable(Table<?>... table)

<R extends Record> TruncateIdentityStep<R>

DefaultDSLContext.truncateTable(Table<R> table)

static TruncateIdentityStep<Record>

DSL.truncateTable(Table<?>... table)

The TRUNCATE TABLE statement.

static <R extends Record> TruncateIdentityStep<R>

DSL.truncateTable(Table<R> table)

The TRUNCATE TABLE statement.

<R extends Record> UpdateSetFirstStep<R>

DefaultDSLContext.update(Table<R> table)

static <R extends Record> @NotNull UpdateSetFirstStep<R>

DSL.update(Table<R> table)

Create a new DSL update statement.

<R extends Record> UpdateQuery<R>

DefaultDSLContext.updateQuery(Table<R> table)

Method parameters in org.jooq.impl with type arguments of type Table

Modifier and Type

Method

Description

@NotNull QOM.Update<R>

QOM.Update.$from(Collection<? extends Table<?>> from)

@NotNull QOM.Truncate<R>

QOM.Truncate.$table(Collection<? extends Table<?>> table)

@NotNull QOM.Delete<R>

QOM.Delete.$using(Collection<? extends Table<?>> using)

Queries

DefaultDSLContext.ddl(Collection<? extends Table<?>> tables)

Queries

DefaultDSLContext.ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration exportConfiguration)

Queries

DefaultDSLContext.ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)

static final Replacer

Internal.mappingTable(Function<? super Table<?>,? extends Table<?>> replacement)

The implementation of Replacers.mappingTable(Function).

static final Replacer

Internal.mappingTable(Function<? super Table<?>,? extends Table<?>> replacement)

The implementation of Replacers.mappingTable(Function).

final CallbackParseListener

CallbackParseListener.onParseTable(Function<? super ParseContext,? extends Table<?>> newOnParseTable)

TruncateIdentityStep<Record>

DefaultDSLContext.truncate(Collection<? extends Table<?>> table)

static TruncateIdentityStep<Record>

DSL.truncate(Collection<? extends Table<?>> table)

The TRUNCATE statement.

TruncateIdentityStep<Record>

DefaultDSLContext.truncateTable(Collection<? extends Table<?>> table)

static TruncateIdentityStep<Record>

DSL.truncateTable(Collection<? extends Table<?>> table)

The TRUNCATE TABLE statement.

Constructors in org.jooq.impl with parameters of type Table

Modifier

Constructor

Description

protected

CustomRecord(Table<R> table)

protected

DAOImpl(Table<R> table, Class<P> type)

protected

DAOImpl(Table<R> table, Class<P> type, Configuration configuration)

TableImpl(String name, Schema schema, Table<R> aliased)

Deprecated.
- 3.10 - [#5996] - Use TableImpl(Name, Schema, Table) instead (or re-generated your code).

TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters)

Deprecated.
- 3.10 - [#5996] - Use TableImpl(Name, Schema, Table, Field[]) instead (or re-generated your code).

TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)

Deprecated.
- 3.10 - [#5996] - Use TableImpl(Name, Schema, Table, Field[], String) instead (or re-generated your code).

TableImpl(Name name, Schema schema, Table<?> path, ForeignKey<?,R> childPath, InverseForeignKey<?,R> parentPath, Table<R> aliased, Field<?>[] parameters, Comment comment)

TableImpl(Name name, Schema schema, Table<?> path, ForeignKey<?,R> childPath, InverseForeignKey<?,R> parentPath, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)

Deprecated.
- [#8012] - 3.19.0 - Please re-generate your code.

TableImpl(Name name, Schema schema, Table<?> path, ForeignKey<?,R> childPath, InverseForeignKey<?,R> parentPath, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options, Condition where)

TableImpl(Name name, Schema schema, Table<?> path, ForeignKey<?,R> childPath, Table<R> aliased, Field<?>[] parameters, Comment comment)

Deprecated.
- [#13639] [#14985] [#15005] - 3.19.0 - Please re-generate your code.

TableImpl(Name name, Schema schema, Table<?> path, ForeignKey<?,R> childPath, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)

Deprecated.
- [#13639] [#14985] [#15005] - 3.19.0 - Please re-generate your code.

TableImpl(Name name, Schema schema, Table<R> aliased)

TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters)

TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)

Deprecated.
- 3.11 - [#7027] - Use TableImpl(Name, Schema, Table, Field[], Comment) instead.

TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment)

TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)

TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options, Condition where)

TableImpl(Table<?> path, ForeignKey<?,R> childPath, InverseForeignKey<?,R> parentPath, Table<R> aliased)

TableImpl(Table<?> path, ForeignKey<?,R> childPath, Table<R> aliased)

Deprecated.
- [#13639] [#14985] [#15005] - 3.19.0 - Please re-generate your code.

TableMetaProvider(Configuration configuration, Table<?>... tables)

TableRecordImpl(Table<R> table)

UpdatableRecordImpl(Table<R> table)

Constructor parameters in org.jooq.impl with type arguments of type Table

Modifier

Constructor

Description

TableMetaProvider(Configuration configuration, Collection<? extends Table<?>> tables)
Uses of Table in org.jooq.util.postgres

Methods in org.jooq.util.postgres that return Table

Modifier and Type

Method

Description

static @NotNull Table<Record>

PostgresDSL.only(Table<?> table)

Get the PostgreSQL-specific ONLY [table] clause for use with table inheritance.

Methods in org.jooq.util.postgres with parameters of type Table

Modifier and Type

Method

Description

static @NotNull Field<Long>

PostgresDSL.oid(Table<?> table)

Deprecated, for removal: This API element is subject to removal in a future version.
- [#12420] - 3.16.0 - Use actual OID column references in jOOQ-meta, instead.

static @NotNull Table<Record>

PostgresDSL.only(Table<?> table)

Get the PostgreSQL-specific ONLY [table] clause for use with table inheritance.

Uses of Interfaceorg.jooq.Table

Uses of Table in org.jooq

Uses of Table in org.jooq.impl

Uses of Table in org.jooq.util.postgres

Uses of Interface
org.jooq.Table