Uses of Interface
org.jooq.Table

Packages that use Table

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes.

Uses of Table in org.jooq

Subinterfaces of Table in org.jooq

Modifier and Type	Interface and Description
interface	TableOnConditionStep An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
interface	TableOptionalOnStep An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)

Methods in org.jooq that return Table

Modifier and Type	Method and Description
Table<R>	Table.as(String alias) Create an alias for this table Note that the case-sensitivity of the returned table depends on Settings.getRenderNameStyle().
Table<R>	Table.as(String alias, String... fieldAliases) Create an alias for this table and its fields Note that the case-sensitivity of the returned table and columns depends on Settings.getRenderNameStyle().
Table<R>	TableLike.asTable() The underlying table representation of this object This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
Table<R>	TableLike.asTable(String alias) The underlying aliased table representation of this object
Table<R>	TableLike.asTable(String alias, String... fieldAliases) The underlying aliased table representation of this object
Table<Record>	Table.crossJoin(String sql) CROSS JOIN a table to this table.
Table<Record>	Table.crossJoin(String sql, Object... bindings) CROSS JOIN a table to this table.
Table<Record>	Table.crossJoin(String sql, QueryPart... parts) CROSS JOIN a table to this table.
Table<Record>	Table.crossJoin(TableLike<?> table) CROSS JOIN a table to this table.
Table<R>	TableRecord.getTable() The table from which this record was read
Table<R>	TableField.getTable()
Table<R>	Key.getTable() The Key's owner table
Table<R>	Identity.getTable() The IDENTITY's owner table
Table<R>	DAO.getTable() Get the underlying table
Table<?>	Schema.getTable(String name) Get a table by its name (case-sensitive) in this schema, or null if no such table exists
Table<Record>	PivotInStep.in(Collection<? extends Field<T>> fields) Specify the acceptable values for pivoting This clause is generally only supported by SQLDialect.ORACLE.
Table<Record>	PivotInStep.in(Field<?>... fields) Specify the acceptable values for pivoting This clause is generally only supported by SQLDialect.ORACLE.
Table<Record>	PivotInStep.in(T... values) Specify the acceptable values for pivoting
<R extends Record> Table<R>	SchemaMapping.map(Table<R> table) Deprecated. Apply mapping to a given table
<R extends Record> Table<R>	DSLContext.map(Table<R> table) Map a table to another one.
Table<Record>	Table.naturalJoin(String sql) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalJoin(String sql, Object... bindings) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalJoin(String sql, QueryPart... parts) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalJoin(TableLike<?> table) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(String sql) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(String sql, Object... bindings) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(TableLike<?> table) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(String sql) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(TableLike<?> table) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	DivideByReturningStep.returning(Collection<? extends Field<?>> fields) Specify the fields that you want the division to return from the dividend
Table<Record>	DivideByReturningStep.returning(Field<?>... fields) Specify the fields that you want the division to return from the dividend
Table<Record>	TableOnStep.using(Collection<? extends Field<?>> fields) Join the table with the USING(column [, column...])
Table<Record>	TableOnStep.using(Field<?>... fields) Join the table with the USING(column [, column...])
Table<R>	Table.with(String hint) Specify a SQL Server style table hint for query optimisation This makes sense only on an actual database table or view, not on other composed table sources.

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

Modifier and Type	Method and Description
List<Table<?>>	Schema.getTables() List all tables contained in this schema
List<Table<?>>	Meta.getTables() Get all table objects from the underlying DatabaseMetaData

Methods in org.jooq with parameters of type Table

Modifier and Type	Method and Description
void	SchemaMapping.add(Table<?> inputTable, String outputTable) Deprecated. Add tables to this mapping
void	SchemaMapping.add(Table<?> inputTable, Table<?> outputTable) Deprecated. Add tables to this mapping
void	SchemaMapping.add(Table<?> inputTable, Table<?> outputTable) Deprecated. Add tables to this mapping
<R extends Record> DeleteWhereStep<R>	DSLContext.delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> DeleteQuery<R>	DSLContext.deleteQuery(Table<R> table) Create a new DeleteQuery
DivideByOnStep	Table.divideBy(Table<?> divisor) Create a new TABLE reference from this table, applying relational division.
<R extends Record> Result<R>	DSLContext.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table] The result and its contained records are attached to this Configuration by default.
<R extends Record> Result<R>	DSLContext.fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition] The result and its contained records are attached to this Configuration by default.
<R extends Record> R	DSLContext.fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] LIMIT 1 The resulting record is attached to this Configuration by default.
<Z extends Record> Result<Z>	ResultQuery.fetchInto(Table<Z> table) Map resulting records onto a custom record.
<Z extends Record> Result<Z>	Cursor.fetchInto(Table<Z> table) Map resulting records onto a custom record.
<R extends Record> Cursor<R>	DSLContext.fetchLazy(Table<R> table) Execute and return all records lazily for SELECT * FROM [table] The result and its contained records are attached to this Configuration by default.
<R extends Record> Cursor<R>	DSLContext.fetchLazy(Table<R> table, Condition condition) Execute and return all records lazily for SELECT * FROM [table] WHERE [condition] The result and its contained records are attached to this Configuration by default.
<R extends Record> R	DSLContext.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] The resulting record is attached to this Configuration by default.
<R extends Record> R	DSLContext.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] The resulting record is attached to this Configuration by default.
<Z extends Record> Z	ResultQuery.fetchOneInto(Table<Z> table) Map resulting records onto a custom record.
<Z extends Record> Z	Cursor.fetchOneInto(Table<Z> table) Map the next resulting record onto a custom record.
<O extends Record> List<ForeignKey<O,R>>	Table.getReferencesFrom(Table<O> other) Get a list of FOREIGN KEY's of a specific table, referencing a this table.
<O extends Record> List<ForeignKey<R,O>>	Table.getReferencesTo(Table<O> other) Get a list of FOREIGN KEY's of this table, referencing a specific table.
<R extends Record> InsertSetStep<R>	DSLContext.insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStepN<R>	DSLContext.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStepN<R>	DSLContext.insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record,T1> InsertValuesStep1<R,T1>	DSLContext.insertInto(Table<R> into, Field<T1> field1) Create a new DSL insert statement.
<R extends Record,T1,T2> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> InsertQuery<R>	DSLContext.insertQuery(Table<R> into) Create a new InsertQuery
<R extends Record> R	Record.into(Table<R> table) Map resulting records onto a custom record type.
<Z extends Record> Result<Z>	Result.into(Table<Z> table) Map resulting records onto a custom record.
<R extends TableRecord<R>> LoaderOptionsStep<R>	DSLContext.loadInto(Table<R> table) Create a new Loader object to load data from a CSV or XML source.
<R extends Record> Table<R>	SchemaMapping.map(Table<R> table) Deprecated. Apply mapping to a given table
<R extends Record> Table<R>	DSLContext.map(Table<R> table) Map a table to another one.
<R extends Record> MergeUsingStep<R>	DSLContext.mergeInto(Table<R> table) Create a new DSL SQL standard MERGE statement.
<R extends Record> MergeKeyStepN<R>	DSLContext.mergeInto(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax)
<R extends Record> MergeKeyStepN<R>	DSLContext.mergeInto(Table<R> table, Field<?>... fields) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1> MergeKeyStep1<R,T1>	DSLContext.mergeInto(Table<R> table, Field<T1> field1) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2> MergeKeyStep2<R,T1,T2>	DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3> MergeKeyStep3<R,T1,T2,T3>	DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4>	DSLContext.mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5> 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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6> 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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7> 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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> 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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> 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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<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>	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) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record> R	DSLContext.newRecord(Table<R> table) Create a new Record that can be inserted into the corresponding table.
<R extends Record> R	DSLContext.newRecord(Table<R> table, Object source) Create a new pre-filled Record that can be inserted into the corresponding table.
<R extends Record> Result<R>	DSLContext.newResult(Table<R> table) Create a new empty Result.
SelectForUpdateWaitStep<R>	SelectForUpdateOfStep.of(Table<?>... tables) Add an OF clause to the FOR UPDATE clause at the end of the query.
<R extends Record> SelectWhereStep<R>	DSLContext.selectFrom(Table<R> table) Create a new DSL select statement.
void	SelectQuery.setForUpdateOf(Table<?>... tables) Some RDBMS allow for specifying the tables that should be locked by the FOR UPDATE clause, instead of the full row.
<R extends Record> Truncate<R>	DSLContext.truncate(Table<R> table) Create a new DSL truncate statement.
<R extends Record> UpdateSetFirstStep<R>	DSLContext.update(Table<R> table) Create a new DSL update statement.
<R extends Record> UpdateQuery<R>	DSLContext.updateQuery(Table<R> table) Create a new UpdateQuery

Uses of Table in org.jooq.impl

Classes in org.jooq.impl that implement Table

Modifier and Type	Class and Description
class	CustomTable<R extends TableRecord<R>> A base class for custom Table implementations in client code.
class	TableImpl<R extends Record> A common base type for tables This type is for JOOQ INTERNAL USE only.

Methods in org.jooq.impl that return Table

Modifier and Type	Method and Description
Table<R>	TableImpl.as(String as) Subclasses may override this method to provide custom aliasing implementations Create an alias for this table Note that the case-sensitivity of the returned table depends on Settings.getRenderNameStyle().
Table<R>	TableImpl.as(String as, String... fieldAliases) Subclasses may override this method to provide custom aliasing implementations Create an alias for this table and its fields Note that the case-sensitivity of the returned table and columns depends on Settings.getRenderNameStyle().
Table<R>	TableRecordImpl.getTable()
Table<R>	DAOImpl.getTable()
Table<?>	SchemaImpl.getTable(String name)
static Table<?>	DSL.table(ArrayRecord<?> array) A synonym for DSL.unnest(ArrayRecord).
static Table<?>	DSL.table(Field<?> cursor) A synonym for DSL.unnest(Field).
static Table<?>	DSL.table(List<?> list) A synonym for DSL.unnest(List).
static Table<?>	DSL.table(Object[] array) A synonym for DSL.unnest(Object[]).
static <R extends Record> Table<R>	DSL.table(Select<R> select) A synonym for TableLike.asTable(), which might look a bit more fluent like this, to some users
static Table<Record>	DSL.table(String sql) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	DSL.table(String sql, Object... bindings) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	DSL.table(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	DSL.tableByName(String... qualifiedName) Create a qualified table, given its table name.
static Table<?>	DSL.unnest(ArrayRecord<?> array) Create a table from an array of values.
static Table<?>	DSL.unnest(Field<?> cursor) Create a table from a field.
static Table<?>	DSL.unnest(List<?> list) Create a table from a list of values.
static Table<?>	DSL.unnest(Object[] array) Create a table from an array of values.
static <T1> Table<Record1<T1>>	DSL.values(Row1<T1>... rows) Create a VALUES() expression of degree 1.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Table<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	DSL.values(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows) Create a VALUES() expression of degree 10.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Table<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	DSL.values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... rows) Create a VALUES() expression of degree 11.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Table<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	DSL.values(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... rows) Create a VALUES() expression of degree 12.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Table<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	DSL.values(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... rows) Create a VALUES() expression of degree 13.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Table<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	DSL.values(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>... rows) Create a VALUES() expression of degree 14.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Table<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	DSL.values(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>... rows) Create a VALUES() expression of degree 15.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Table<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	DSL.values(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows) Create a VALUES() expression of degree 16.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Table<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	DSL.values(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>... rows) Create a VALUES() expression of degree 17.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Table<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	DSL.values(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows) Create a VALUES() expression of degree 18.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Table<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	DSL.values(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows) Create a VALUES() expression of degree 19.
static <T1,T2> Table<Record2<T1,T2>>	DSL.values(Row2<T1,T2>... rows) Create a VALUES() expression of degree 2.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Table<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	DSL.values(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>... rows) Create a VALUES() expression of degree 20.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Table<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	DSL.values(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>... rows) Create a VALUES() expression of degree 21.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Table<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>	DSL.values(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>... rows) Create a VALUES() expression of degree 22.
static <T1,T2,T3> Table<Record3<T1,T2,T3>>	DSL.values(Row3<T1,T2,T3>... rows) Create a VALUES() expression of degree 3.
static <T1,T2,T3,T4> Table<Record4<T1,T2,T3,T4>>	DSL.values(Row4<T1,T2,T3,T4>... rows) Create a VALUES() expression of degree 4.
static <T1,T2,T3,T4,T5> Table<Record5<T1,T2,T3,T4,T5>>	DSL.values(Row5<T1,T2,T3,T4,T5>... rows) Create a VALUES() expression of degree 5.
static <T1,T2,T3,T4,T5,T6> Table<Record6<T1,T2,T3,T4,T5,T6>>	DSL.values(Row6<T1,T2,T3,T4,T5,T6>... rows) Create a VALUES() expression of degree 6.
static <T1,T2,T3,T4,T5,T6,T7> Table<Record7<T1,T2,T3,T4,T5,T6,T7>>	DSL.values(Row7<T1,T2,T3,T4,T5,T6,T7>... rows) Create a VALUES() expression of degree 7.
static <T1,T2,T3,T4,T5,T6,T7,T8> Table<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	DSL.values(Row8<T1,T2,T3,T4,T5,T6,T7,T8>... rows) Create a VALUES() expression of degree 8.
static <T1,T2,T3,T4,T5,T6,T7,T8,T9> Table<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	DSL.values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows) Create a VALUES() expression of degree 9.

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

Modifier and Type	Method and Description
List<Table<?>>	SchemaImpl.getTables() List all tables contained in this schema

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

Modifier and Type	Method and Description
protected static <R extends Record,U extends Record> ForeignKey<R,U>	AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields) Factory method for foreign keys
protected static <R extends Record,T> Identity<R,T>	AbstractKeys.createIdentity(Table<R> table, TableField<R,T> field) Factory method for identities
protected static <R extends Record> UniqueKey<R>	AbstractKeys.createUniqueKey(Table<R> table, TableField<R,?>... fields) Factory method for unique keys
static <R extends Record> SelectWhereStep<R>	DSL.selectFrom(Table<R> table) Create a new DSL select statement.

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

Constructor and Description
CustomRecord(Table<R> table)
DAOImpl(Table<R> table, Class<P> type)
DAOImpl(Table<R> table, Class<P> type, Configuration configuration)
TableImpl(String name, Schema schema, Table<R> aliased)
TableRecordImpl(Table<R> table)
UpdatableRecordImpl(Table<R> table)