Uses of Interface
org.jooq.Table
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
This package contains classes related to the
SQLDialect.POSTGRES
dialect family.-
Uses of Table in org.jooq
Modifier and TypeInterfaceDescriptioninterface
CommonTableExpression<R extends Record>
A common table expression.interface
A step in the construction of anJSON_TABLE
expression.interface
A step in the construction of anJSON_TABLE
expression.interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
interface
A step in the construction of anXMLTABLE
expression.interface
A step in the construction of anXMLTABLE
expression.Modifier and TypeMethodDescriptionAdd anAND
clause to the flashback versions query clause.Add anAND
clause to the flashback versions query clause.VersionsBetweenAndStep.andMaxvalue()
Add anAND MAXVALUE
clause to the flashback versions query clause.Create an alias for this table.Create an alias for this table and its fields.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.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.Create an alias for this table.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.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.Create an alias for this table and its fields.Create an alias for this table based on another table's name.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.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.Create an alias for this table based on another table's name.Create anSQLDialect.ORACLE
flashback query clause from this table.Create anSQLDialect.ORACLE
flashback query clause from this table.Table.asOfTimestamp(Timestamp timestamp)
Create anSQLDialect.ORACLE
flashback query clause from this table.Table.asOfTimestamp(Field<Timestamp> timestamp)
Create anSQLDialect.ORACLE
flashback query clause from this table.TableLike.asTable()
The underlying table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.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.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.The underlying aliased table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.A table reference of this table at a givenLink
.A table reference of this table at a givenLink
.A table reference of this table at a givenLink
.ForeignKey.children(Collection<? extends O> records)
Get a table expression representing the children of a record, given this foreign key.Get a table expression representing the children of a record, given this foreign key.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.Table.crossApply(String sql)
CROSS APPLY
a table to this table.Table.crossApply(String sql, Object... bindings)
CROSS APPLY
a table to this table.Table.crossApply(String sql, QueryPart... parts)
CROSS APPLY
a table to this table.Table.crossApply(Name name)
CROSS APPLY
a table to this table.Table.crossApply(SQL sql)
CROSS APPLY
a table to this table.Table.crossApply(TableLike<?> table)
CROSS APPLY
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.Table.for_(PeriodSpecification periodSpecification)
Create a reference to a temporal table with aPeriodSpecification
for usage inSelect
.Table.forceIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.forceIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.forceIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.forceIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.forPortionOf(PeriodSpecification periodSpecification)
Check.getTable()
TheKey
's owner tableDAO.getTable()
Get the underlying table.Identity.getTable()
TheIDENTITY
's owner table@Nullable Table<?>
Index.getTable()
The table on which this index is defined.Key.getTable()
TheKey
's owner table@Nullable Table<?>
Get a table by its name (case-sensitive) in this schema, ornull
if no such table exists.@Nullable Table<?>
Get a table by its qualified or unqualified name in this schema, ornull
if no such table exists.TableField.getTable()
TableRecord.getTable()
The table from which this record was read.Table.ignoreIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.ignoreIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.ignoreIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.ignoreIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.PivotInStep.in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivotingSpecify the acceptable values for pivotingSpecify the acceptable values for pivotingMap a table to another one.Deprecated, for removal: This API element is subject to removal in a future version.Apply mapping to a given tableTable.naturalFullOuterJoin(String sql)
NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin(String sql, Object... bindings)
NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin(String sql, QueryPart... parts)
NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin(Name name)
NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin(SQL sql)
NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin(TableLike<?> table)
NATURAL FULL OUTER JOIN
a table to this table.Table.naturalJoin(String sql)
NATURAL JOIN
a table to this table.Table.naturalJoin(String sql, Object... bindings)
NATURAL JOIN
a table to this table.Table.naturalJoin(String sql, QueryPart... parts)
NATURAL JOIN
a table to this table.Table.naturalJoin(Name name)
NATURAL JOIN
a table to this table.Table.naturalJoin(SQL sql)
NATURAL JOIN
a table to this table.Table.naturalJoin(TableLike<?> table)
NATURAL JOIN
a table to this table.Table.naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin(String sql, Object... bindings)
NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin(String sql, QueryPart... parts)
NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin(String sql, Object... bindings)
NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin(String sql, QueryPart... parts)
NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin(SQL sql)
NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN
a table to this table.Table.outerApply(String sql)
OUTER APPLY
a table to this table.Table.outerApply(String sql, Object... bindings)
OUTER APPLY
a table to this table.Table.outerApply(String sql, QueryPart... parts)
OUTER APPLY
a table to this table.Table.outerApply(Name name)
OUTER APPLY
a table to this table.Table.outerApply(SQL sql)
OUTER APPLY
a table to this table.Table.outerApply(TableLike<?> table)
OUTER APPLY
a table to this table.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.ForeignKey.parents(Collection<? extends R> records)
Get a table expression representing the parents of a record, given this foreign key.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 aTable
expression or fail if the current expression is not a table.@Nullable Table<?>
ParseListener.parseTable(ParseContext ctx)
Attempt to parse aTable
expression.@NotNull Table<?>
Parser.parseTable(String sql)
Parse a SQL string to a table.@NotNull Table<?>
Parser.parseTable(String sql, Object... bindings)
Parse a SQL string with bind variables to a table.@NotNull Table<?>
QualifiedAsterisk.qualifier()
The qualifier.DivideByReturningStep.returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividendSpecify the fields that you want the division to return from the dividendSpecify a MySQL style table hint for query optimisation.Table.useIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.useIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.Table.useIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.TableOnStep.using(Collection<? extends Field<?>> fields)
Join a table with theUSING(column [, column...])
syntax.Join a table with theUSING(column [, column...])
syntax.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Table.where(Collection<? extends Condition> conditions)
Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Table.whereExists(Select<?> select)
Add aWHERE EXISTS
clause to the table.Table.whereNotExists(Select<?> select)
Add aWHERE NOT EXISTS
clause to the table.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Modifier and TypeMethodDescriptionMeta.getTables()
Get all table objects from the underlying meta data source.Get all table objects by name from the underlying meta data source.Get all table objects by name from the underlying meta data source.Schema.getTables()
List all tables contained in this schema.Schema.tableStream()
Stream all tables contained in this schema.Modifier and TypeMethodDescriptionvoid
Deprecated, for removal: This API element is subject to removal in a future version.Add tables to this mappingvoid
Deprecated, for removal: This API element is subject to removal in a future version.Add tables to this mapping@NotNull AlterTableStep
DSLContext.alterTable(Table<?> table)
Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
DSLContext.alterTableIfExists(Table<?> table)
Create a new DSLALTER TABLE
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
DSLContext.alterViewIfExists(Table<?> view)
TheALTER VIEW IF EXISTS
statement.Create an alias for this table based on another table's name.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.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.Create an alias for this table based on another table's name.The underlying aliased table representation of this object.The underlying aliased table representation of this object.<X extends Record>
@NotNull ResultQuery<X>Coerce the result record type of this query to that of a table.@NotNull CommentOnIsStep
DSLContext.commentOnTable(Table<?> table)
TheCOMMENT ON TABLE
statement.@NotNull CommentOnIsStep
DSLContext.commentOnView(Table<?> view)
TheCOMMENT ON VIEW
statement.@NotNull CreateTableColumnStep
DSLContext.createGlobalTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
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)
Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateTableColumnStep
DSLContext.createTable(Table<?> table)
Create a new DSLCREATE TABLE
statement.@NotNull CreateTableColumnStep
DSLContext.createTableIfNotExists(Table<?> table)
Create a new DSLCREATE TABLE
statement.@NotNull CreateTableColumnStep
DSLContext.createTemporaryTable(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.@NotNull CreateTableColumnStep
DSLContext.createTemporaryTableIfNotExists(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE IF NOT EXISTS
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)
Create a new DSLCREATE VIEW
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)
Create a new DSLCREATE VIEW
statement.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
Convenience method forMeta.ddl()
.@NotNull Queries
DSLContext.ddl(Table<?>[] tables, DDLExportConfiguration configuration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
DSLContext.ddl(Table<?> table, DDLExportConfiguration configuration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
Convenience method forMeta.ddl(DDLExportConfiguration)
.<R extends Record>
@NotNull DeleteUsingStep<R>Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>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 newDeleteQuery
@NotNull DivideByOnStep
Create a newTABLE
reference from this table, applying relational division.@NotNull DropTableStep
TheDROP TABLE
statement.@NotNull DropTableStep
DSLContext.dropTableIfExists(Table<?> table)
TheDROP TABLE IF EXISTS
statement.@NotNull DropTableStep
DSLContext.dropTemporaryTable(Table<?> table)
TheDROP TEMPORARY TABLE
statement.@NotNull DropTableStep
DSLContext.dropTemporaryTableIfExists(Table<?> table)
TheDROP TEMPORARY TABLE IF EXISTS
statement.@NotNull DropViewFinalStep
TheDROP VIEW
statement.@NotNull DropViewFinalStep
DSLContext.dropViewIfExists(Table<?> view)
TheDROP VIEW IF EXISTS
statement.@NotNull Condition
Create a predicate comparing records from self-joined tables.@NotNull Condition
Create a predicate comparing records from self-joined tables.Execute and return all records forDSLContext.fetch(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records forExecute and return all records forExecute and return all records for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchAny(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or on e record for<Z extends Record>
ZResultQuery.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 forint
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.ResultQuery.fetchGroups(Table<S> table)
Execute the query and return aMap
with the result grouped by the given table.ResultQuery.fetchGroups(Table<S> table, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchGroups(Table<S> table, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.ResultQuery.fetchGroups(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with the result grouped by the given table.Map resulting records onto a custom record.Map resulting records onto a custom record.Execute and return all records lazily forDSLContext.fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily forExecute and return all records lazily forExecute and return all records lazily forExecute the query and return aMap
with table as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchMap(Table<S> table, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.Execute the query and return aMap
with table as a map key and the corresponding record as value.<Z extends Record>
ZCursor.fetchNextInto(Table<Z> table)
Map the next resulting record onto a custom record.Cursor.fetchNextOptionalInto(Table<Z> table)
Map the next resulting record onto a custom record.<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<Z extends Record>
ZCursor.fetchOneInto(Table<Z> table)
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)
instead.<Z extends Record>
ZResultQuery.fetchOneInto(Table<Z> table)
Map resulting records onto a custom record.DSLContext.fetchOptional(Table<R> table)
Execute and return zero or one record forDSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record forDSLContext.fetchOptional(Table<R> table, Condition condition)
Execute and return zero or one record forDSLContext.fetchOptional(Table<R> table, Condition... conditions)
Execute and return zero or one record forCursor.fetchOptionalInto(Table<Z> table)
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.ResultQuery.fetchOptionalInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
RDSLContext.fetchSingle(Table<R> table)
Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions)
Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition condition)
Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition... conditions)
Execute and return exactly one record for<Z extends Record>
ZResultQuery.fetchSingleInto(Table<Z> table)
Map resulting records onto a custom record.DSLContext.fetchStream(Table<R> table)
Execute and return all records lazily forDSLContext.fetchStream(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily forDSLContext.fetchStream(Table<R> table, Condition condition)
Execute and return all records lazily forDSLContext.fetchStream(Table<R> table, Condition... conditions)
Execute and return all records lazily forResultQuery.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.void
Formattable.formatInsert(OutputStream stream, Table<?> table, Field<?>... fields)
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.void
Formattable.formatInsert(Writer writer, Table<?> table, Field<?>... fields)
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anWriter
.@NotNull String
Formattable.formatInsert(Table<?> table, Field<?>... fields)
Get this result as a set ofINSERT
statements.<O extends Record>
@NotNull List<ForeignKey<O,R>>Table.getReferencesFrom(Table<O> other)
Get a list ofFOREIGN 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 ofFOREIGN KEY
's of this table, referencing a specific table.@NotNull InformationSchema
DSLContext.informationSchema(Table<?> table)
Convenience method forMeta.informationSchema()
.@NotNull InformationSchema
DSLContext.informationSchema(Table<?>... table)
Convenience method forMeta.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 newInsertQuery
<R extends Record>
RMap resulting records onto a custom record type.Map resulting records onto a custom record.@NotNull SelectFromStep<Record>
Add a T-SQL styleINTO
clause to theSELECT
statement to create a new table from aSELECT
statement.Result.intoGroups(Table<S> table)
Return aMap
with the result grouped by the given key table.Result.intoGroups(Table<S> table, Class<? extends E> type)
Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoGroups(Table<S> table, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoGroups(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the result grouped by the given key table.Return aMap
with the given key table as a map key and the corresponding record as value.Return aMap
with results grouped by the given key table and mapped into the given entity type.Result.intoMap(Table<S> table, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given key table and mapped by the given mapper.Return aMap
with the given key table as a map key and the corresponding record as value.<R extends Record>
@NotNull LoaderOptionsStep<R>Create a newLoader
object to load data from a CSV or XML source.Map a table to another one.Deprecated, for removal: This API element is subject to removal in a future version.Apply mapping to a given table<R extends Record>
@NotNull MergeUsingStep<R>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, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeKeyStepN<R>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, viaDSLContext.mergeInto(Table)
<R extends Record, T1>
@NotNull MergeKeyStep1<R,T1>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, viaDSLContext.mergeInto(Table)
<R extends Record, T1, T2>
@NotNull MergeKeyStep2<R,T1,T2>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, viaDSLContext.mergeInto(Table)
<R extends Record, T1, T2, T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.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, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeUsingStep<R>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>Create a new DSL merge statement (H2-specific syntax).<R extends Record, T1>
@NotNull MergeKeyStep1<R,T1>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, viaWithStep.mergeInto(Table)
<R extends Record, T1, T2>
@NotNull MergeKeyStep2<R,T1,T2>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, viaWithStep.mergeInto(Table)
<R extends Record, T1, T2, T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.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, viaWithStep.mergeInto(Table)
@NotNull Meta
Access the database meta data from explicit table information.@NotNull Condition
Create a predicate comparing records from self-non-equi-joined tables.<R extends Record>
RCreate a newRecord
that can be inserted into the corresponding table.<R extends Record>
RCreate a new pre-filledRecord
that can be inserted into the corresponding table.Create a new emptyResult
.@NotNull Condition
Create a predicate comparing records from self-non-equi-joined tables.@NotNull SelectForUpdateWaitStep<R>
Add anOF
clause to theFOR <lock_mode>
clause at the end of the query.@NotNull AlterIndexStep
Add theON
clause to theALTER INDEX
statement.@NotNull CreateIndexIncludeStep
CreateIndexStep.on(Table<?> table, Collection<? extends OrderField<?>> on)
Add theON
clause to theCREATE INDEX
statement.@NotNull CreateIndexIncludeStep
CreateIndexStep.on(Table<?> table, OrderField<?>... on)
Add theON
clause to theCREATE INDEX
statement.@NotNull CreateTriggerReferencingStep
Add theON
clause to theCREATE TRIGGER
statement.@NotNull DropIndexCascadeStep
Add theON
clause to theDROP INDEX
statement.@NotNull GrantToStep
Add theON
clause to theGRANT
statement.@NotNull RevokeFromStep
Add theON
clause to theREVOKE
statement.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1.references(Table<?> table, Field<T1> field1)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep2.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4.references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, 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 aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyReferencesStepN.references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyReferencesStepN.references(Table<?> table, Collection<? extends Field<?>> fields)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyReferencesStepN.references(Table<?> table, Field<?>... fields)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull AlterTableFinalStep
Add aRENAME TO
clause to theALTER TABLE
statement.@NotNull AlterViewFinalStep
Add theRENAME TO
clause to theALTER VIEW
statement.<R extends Record>
@NotNull SelectWhereStep<R>DSLContext.selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R>WithStep.selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.void
SelectQuery.setForLockModeOf(Table<?>... tables)
Some RDBMS allow for specifying the tables that should be locked by theFOR <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 - UseSelectQuery.setForLockModeOf(Table...)
void
Add a T-SQL styleINTO
clause to theSELECT
statement to create a new table from aSELECT
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>TheTRUNCATE
statement.<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext.truncateTable(Table<R> table)
TheTRUNCATE TABLE
statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
@NotNull UpdateQuery<R>DSLContext.updateQuery(Table<R> table)
Create a newUpdateQuery
Modifier and TypeMethodDescription@NotNull Queries
DSLContext.ddl(Collection<? extends Table<?>> tables)
Convenience method forMeta.ddl()
.@NotNull Queries
DSLContext.ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Queries
DSLContext.ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.@NotNull Meta
Meta.filterTables(Predicate<? super Table<?>> filter)
Create a wrapperMeta
instance filtering out some tables.static CallbackParseListener
ParseListener.onParseTable(Function<? super ParseContext,? extends Table<?>> onParseTable)
Create aParseListener
with aParseListener.parseTable(ParseContext)
implementation. -
Uses of Table in org.jooq.impl
Modifier and TypeClassDescriptionclass
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
A common base type for tablesModifier and TypeMethodDescriptionSubclasses may override this method to provide custom aliasing implementationsSubclasses may override this method to provide custom aliasing implementations<O extends TableRecord<O>>
Table<O>UpdatableRecordImpl.children(ForeignKey<O,R> key)
DSL.dual()
TheDUAL
table to be used for syntactic completeness.DSL.generateSeries(int from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries(int from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries(int from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries(int from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries(int from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries(int from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries(Field<Integer> from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries(Field<Integer> from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries(Field<Integer> from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries(Field<Integer> from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries(Field<Integer> from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DAOImpl.getTable()
Table<?>
Table<?>
Table<?>
Table<?>
TableRecordImpl.getTable()
Create aLATERAL
joined table.<O extends UpdatableRecord<O>>
Table<O>TableRecordImpl.parent(ForeignKey<R,O> key)
Table<?>
CallbackParseListener.parseTable(ParseContext ctx)
Table<?>
DefaultParseListener.parseTable(ParseContext ctx)
Create aROWS FROM (tables...)
expression.static @NotNull Table<?>
A synonym forDSL.unnest(Object[])
.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<?>
DSL.table(Collection<?> list)
A synonym forDSL.unnest(Collection)
.static @NotNull Table<?>
DSL.table(ArrayRecord<?> array)
A synonym forDSL.unnest(ArrayRecord)
.static @NotNull Table<?>
A synonym forDSL.unnest(Field)
.Create a qualified table, given its table name.Create a qualified table, given its table name.Use a previously obtained result as a newTable
that can be used in SQL statements throughDSL.values(RowN...)
.A synonym forTableLike.asTable()
, which might look a bit more fluent like this, to some users.A custom SQL clause that can render arbitrary table expressions.DSL.table(R record)
Use a previously obtained record as a new TableDSL.table(R... records)
Use a previously obtained set of records as a new TableDSL.tableByName(String... qualifiedName)
Deprecated, for removal: This API element is subject to removal in a future version.- [#3843] - 3.6.0 - useDSL.table(Name)
insteadstatic @NotNull Table<?>
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<?>
Create a table from a field.Create aVALUES()
expression of degree1
.static <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull Table<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>Create aVALUES()
expression of degree10
.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>>Create aVALUES()
expression of degree11
.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>>Create aVALUES()
expression of degree12
.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>>Create aVALUES()
expression of degree13
.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>>Create aVALUES()
expression of degree14
.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>>Create aVALUES()
expression of degree15
.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>>Create aVALUES()
expression of degree16
.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 aVALUES()
expression of degree17
.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 aVALUES()
expression of degree18
.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 aVALUES()
expression of degree19
.Create aVALUES()
expression of degree2
.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 aVALUES()
expression of degree20
.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 aVALUES()
expression of degree21
.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 aVALUES()
expression of degree22
.Create aVALUES()
expression of degree3
.Create aVALUES()
expression of degree4
.Create aVALUES()
expression of degree5
.Create aVALUES()
expression of degree6
.Create aVALUES()
expression of degree7
.static <T1, T2, T3, T4, T5, T6, T7, T8>
@NotNull Table<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>Create aVALUES()
expression of degree8
.static <T1, T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Table<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>Create aVALUES()
expression of degree9
.Create aVALUES()
expression of arbitrary degree.Modifier and TypeMethodDescriptionLazySchema.getTables()
SchemaImpl.getTables()
List all tables contained in this schema.LazySchema.tableStream()
SchemaImpl.tableStream()
Modifier and TypeMethodDescriptionDefaultDSLContext.alterTable(Table<?> table)
static @NotNull AlterTableStep
DSL.alterTable(Table<?> table)
Create a new DSLALTER TABLE
statement.DefaultDSLContext.alterTableIfExists(Table<?> table)
static @NotNull AlterTableStep
DSL.alterTableIfExists(Table<?> table)
Create a new DSLALTER TABLE
statement.static AlterViewStep
TheALTER VIEW
statement.DefaultDSLContext.alterViewIfExists(Table<?> view)
static AlterViewStep
DSL.alterViewIfExists(Table<?> view)
TheALTER VIEW IF EXISTS
statement.DefaultDSLContext.commentOnTable(Table<?> table)
static CommentOnIsStep
DSL.commentOnTable(Table<?> table)
TheCOMMENT ON TABLE
statement.DefaultDSLContext.commentOnView(Table<?> view)
static CommentOnIsStep
DSL.commentOnView(Table<?> view)
TheCOMMENT ON VIEW
statement.static @NotNull AggregateFunction<Integer>
Get the count(table) function.static @NotNull AggregateFunction<Integer>
DSL.countDistinct(Table<?> table)
Get the count(distinct table) function.Internal.createCheck(Table<R> table, Name name, String condition)
Factory method for check constraints.Internal.createCheck(Table<R> table, Name name, String condition, boolean enforced)
Factory method for check constraints.static <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 <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 codestatic <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 codestatic <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)
Factory method for foreign keys.static <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)
Factory method for foreign keys.static <R extends Record, U extends Record>
@NotNull ForeignKey<R,U>Internal.createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <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.- 3.14.0 - [#9404] - Please re-generate your code.static <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.DefaultDSLContext.createGlobalTemporaryTable(Table<?> table)
static @NotNull CreateTableColumnStep
DSL.createGlobalTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.AbstractKeys.createIdentity(Table<R> table, TableField<R,T> field)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeInternal.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 codestatic @NotNull Index
Internal.createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static @NotNull Index
Internal.createIndex(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique)
Factory method for indexes.DefaultDSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
DefaultDSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
DefaultDSLContext.createOrReplaceView(Table<?> view, Field<?>... fields)
static @NotNull CreateViewAsStep
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 @NotNull CreateViewAsStep
DSL.createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.static @NotNull Name
Internal.createPathAlias(Table<?> child, ForeignKey<?,?> path)
Factory method for path aliases.DefaultDSLContext.createTable(Table<?> table)
static @NotNull CreateTableColumnStep
DSL.createTable(Table<?> table)
Create a new DSLCREATE TABLE
statement.DefaultDSLContext.createTableIfNotExists(Table<?> table)
static @NotNull CreateTableColumnStep
DSL.createTableIfNotExists(Table<?> table)
Create a new DSLCREATE TABLE
statement.DefaultDSLContext.createTemporaryTable(Table<?> table)
static @NotNull CreateTableColumnStep
DSL.createTemporaryTable(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.DefaultDSLContext.createTemporaryTableIfNotExists(Table<?> table)
static @NotNull CreateTableColumnStep
DSL.createTemporaryTableIfNotExists(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.AbstractKeys.createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeAbstractKeys.createUniqueKey(Table<R> table, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeInternal.createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.Internal.createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.Internal.createUniqueKey(Table<R> table, Name name, TableField<R,?>... fields)
Factory method for unique keys.Internal.createUniqueKey(Table<R> table, Name name, TableField<R,?>[] fields, boolean enforced)
Factory method for unique keys.static <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.Internal.createUniqueKey(Table<R> table, TableField<R,?>... fields)
Factory method for unique keys.DefaultDSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
DefaultDSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
DefaultDSLContext.createView(Table<?> view, Field<?>... fields)
static @NotNull CreateViewAsStep
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 @NotNull CreateViewAsStep
DSL.createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.DefaultDSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
DefaultDSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
DefaultDSLContext.createViewIfNotExists(Table<?> view, Field<?>... fields)
static @NotNull CreateViewAsStep
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 @NotNull CreateViewAsStep
DSL.createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.DefaultDSLContext.ddl(Table[] tables, DDLExportConfiguration exportConfiguration)
DefaultDSLContext.ddl(Table<?> table, DDLExportConfiguration exportConfiguration)
<R extends Record>
DeleteUsingStep<R>static <R extends Record>
@NotNull DeleteUsingStep<R>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)
static DropTableStep
TheDROP TABLE
statement.DefaultDSLContext.dropTableIfExists(Table<?> table)
static DropTableStep
DSL.dropTableIfExists(Table<?> table)
TheDROP TABLE IF EXISTS
statement.DefaultDSLContext.dropTemporaryTable(Table<?> table)
static DropTableStep
DSL.dropTemporaryTable(Table<?> table)
TheDROP TEMPORARY TABLE
statement.DefaultDSLContext.dropTemporaryTableIfExists(Table<?> table)
static DropTableStep
DSL.dropTemporaryTableIfExists(Table<?> table)
TheDROP TEMPORARY TABLE IF EXISTS
statement.static DropViewFinalStep
TheDROP VIEW
statement.DefaultDSLContext.dropViewIfExists(Table<?> view)
static DropViewFinalStep
DSL.dropViewIfExists(Table<?> view)
TheDROP VIEW IF EXISTS
statement.DefaultDSLContext.fetch(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchAny(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
R<R extends Record>
R<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)
DefaultDSLContext.fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
R<R extends Record>
RDefaultDSLContext.fetchOptional(Table<R> table)
DefaultDSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
DefaultDSLContext.fetchOptional(Table<R> table, Condition condition)
DefaultDSLContext.fetchOptional(Table<R> table, Condition... conditions)
<R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table)
<R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext.fetchSingle(Table<R> table, Condition... conditions)
DefaultDSLContext.fetchStream(Table<R> table)
DefaultDSLContext.fetchStream(Table<R> table, Collection<? extends Condition> conditions)
DefaultDSLContext.fetchStream(Table<R> table, Condition condition)
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)
void
ArrayRecordImpl.formatInsert(Writer writer, Table<?> table, Field<?>... fields)
DefaultDSLContext.informationSchema(Table<?> table)
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><R extends Record>
MergeUsingStep<R><R extends Record>
MergeKeyStepN<R>DefaultDSLContext.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
<R extends Record>
MergeKeyStepN<R><R extends Record, T1>
MergeKeyStep1<R,T1>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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record, T1, T2>
MergeKeyStep2<R,T1,T2>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, viaDefaultDSLContext.mergeInto(Table)
<R extends Record, T1, T2, T3>
MergeKeyStep3<R,T1,T2,T3>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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.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, viaDefaultDSLContext.mergeInto(Table)
static <R extends Record>
@NotNull MergeUsingStep<R>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, viaDSL.mergeInto(Table)
static <R extends Record>
@NotNull MergeKeyStepN<R>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, viaDSL.mergeInto(Table)
static <R extends Record, T1>
@NotNull MergeKeyStep1<R,T1>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, viaDSL.mergeInto(Table)
static <R extends Record, T1, T2>
@NotNull MergeKeyStep2<R,T1,T2>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, viaDSL.mergeInto(Table)
static <R extends Record, T1, T2, T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.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, viaDSL.mergeInto(Table)
<R extends Record>
R<R extends Record>
RCreate aROWS FROM (tables...)
expression.<R extends Record>
SelectWhereStep<R>DefaultDSLContext.selectFrom(Table<R> table)
static <R extends Record>
@NotNull SelectWhereStep<R>DSL.selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
TruncateIdentityStep<R>static <R extends Record>
TruncateIdentityStep<R>TheTRUNCATE
statement.<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext.truncateTable(Table<R> table)
static <R extends Record>
TruncateIdentityStep<R>DSL.truncateTable(Table<R> table)
TheTRUNCATE TABLE
statement.<R extends Record>
UpdateSetFirstStep<R>static <R extends Record>
@NotNull UpdateSetFirstStep<R>Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DefaultDSLContext.updateQuery(Table<R> table)
Modifier and TypeMethodDescriptionDefaultDSLContext.ddl(Collection<? extends Table<?>> tables)
DefaultDSLContext.ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration exportConfiguration)
DefaultDSLContext.ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)
CallbackParseListener.onParseTable(Function<? super ParseContext,? extends Table<?>> newOnParseTable)
ModifierConstructorDescriptionprotected
CustomRecord(Table<R> table)
protected
protected
Deprecated.- 3.10 - [#5996] - UseTableImpl(Name, Schema, Table)
instead (or re-generated your code).Deprecated.- 3.10 - [#5996] - UseTableImpl(Name, Schema, Table, Field[])
instead (or re-generated your code).Deprecated.- 3.10 - [#5996] - UseTableImpl(Name, Schema, Table, Field[], String)
instead (or re-generated your code).TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment)
TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)
Deprecated.- 3.11 - [#7027] - UseTableImpl(Name, Schema, Table, Field[], Comment)
instead.TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)
TableMetaProvider(Configuration configuration, Table<?>... tables)
TableRecordImpl(Table<R> table)
UpdatableRecordImpl(Table<R> table)
ModifierConstructorDescriptionTableMetaProvider(Configuration configuration, Collection<? extends Table<?>> tables)
-
Uses of Table in org.jooq.util.postgres
Modifier and TypeMethodDescriptionGet the PostgreSQL-specificONLY [table]
clause for use with table inheritance.Modifier and TypeMethodDescriptionGet the PostgreSQL-specific[table].oid
column from any table.Get the PostgreSQL-specificONLY [table]
clause for use with table inheritance.