Uses of Interface
org.jooq.Table

Packages that use Table

org.jooq
org.jooq.impl

Uses of Table in org.jooq

Subinterfaces of Table in org.jooq

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	UpdatableTable<R extends Record> A common interface for tables whose records can be stored back to the database again.

Methods in org.jooq that return Table

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 This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') [alias] WHERE ...
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(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<?>	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
Table<?>	SchemaMapping.map(Table<?> table) Deprecated. Apply mapping to a given table
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(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(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(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...])

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

List<Table<?>>

Schema.getTables() List all tables contained in this schema

Methods in org.jooq with parameters of type Table

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>	FactoryOperations.delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> DeleteQuery<R>	FactoryOperations.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 TableRecord<R>> int	FactoryOperations.executeDelete(Table<R> table) Delete records from a table DELETE FROM [table]
<R extends TableRecord<R>,T> int	FactoryOperations.executeDelete(Table<R> table, Condition condition) Delete records from a table DELETE FROM [table] WHERE [condition]
<R extends TableRecord<R>> int	FactoryOperations.executeDeleteOne(Table<R> table) Delete one record in a table DELETE FROM [table]
<R extends TableRecord<R>,T> int	FactoryOperations.executeDeleteOne(Table<R> table, Condition condition) Delete one record in a table DELETE FROM [table] WHERE [condition]
<R extends TableRecord<R>> int	FactoryOperations.executeInsert(Table<R> table, R record) Insert one record INSERT INTO [table] ...
<R extends TableRecord<R>> int	FactoryOperations.executeUpdate(Table<R> table, R record) Update a table UPDATE [table] SET [modified values in record]
<R extends TableRecord<R>,T> int	FactoryOperations.executeUpdate(Table<R> table, R record, Condition condition) Update a table UPDATE [table] SET [modified values in record] WHERE [condition]
<R extends TableRecord<R>> int	FactoryOperations.executeUpdateOne(Table<R> table, R record) Update one record in a table UPDATE [table] SET [modified values in record]
<R extends TableRecord<R>,T> int	FactoryOperations.executeUpdateOne(Table<R> table, R record, Condition condition) Update one record in a table UPDATE [table] SET [modified values in record] WHERE [condition]
<R extends Record> Result<R>	FactoryOperations.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table]
<R extends Record> Result<R>	FactoryOperations.fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition]
<R extends Record> R	FactoryOperations.fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] LIMIT 1
<Z extends Record> Result<Z>	ResultQuery.fetchInto(Table<Z> table) Map resulting records onto a custom record.
<Z extends Record> List<Z>	Cursor.fetchInto(Table<Z> table) Map resulting records onto a custom record.
<R extends Record> R	FactoryOperations.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table]
<R extends Record> R	FactoryOperations.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition]
<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>>	UpdatableTable.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>	FactoryOperations.insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	FactoryOperations.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	FactoryOperations.insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record> Insert<R>	FactoryOperations.insertInto(Table<R> into, Select<?> select) Deprecated. - 2.0.3 - Use any of these methods instead: FactoryOperations.insertInto(Table) and InsertSetStep.select(Select) FactoryOperations.insertInto(Table, Field...) and InsertValuesStep.select(Select) FactoryOperations.insertInto(Table, Collection) and InsertValuesStep.select(Select)
<R extends Record> InsertQuery<R>	FactoryOperations.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>	FactoryOperations.loadInto(Table<R> table) Create a new Loader object to load data from a CSV or XML source
Table<?>	SchemaMapping.map(Table<?> table) Deprecated. Apply mapping to a given table
<R extends Record> MergeUsingStep<R>	FactoryOperations.mergeInto(Table<R> table) Create a new DSL merge statement.
<R extends TableRecord<R>> R	FactoryOperations.newRecord(Table<R> table) Create a new Record that can be inserted into the corresponding table.
<R extends TableRecord<R>> R	FactoryOperations.newRecord(Table<R> table, Object source) Create a new pre-filled Record that can be inserted into the corresponding table.
SimpleSelectForUpdateWaitStep<R>	SimpleSelectForUpdateOfStep.of(Table<?>... tables) Add an OF clause to the FOR UPDATE clause at the end of the query.
SelectForUpdateWaitStep	SelectForUpdateOfStep.of(Table<?>... tables) Add an OF clause to the FOR UPDATE clause at the end of the query.
<R extends Record> SimpleSelectWhereStep<R>	FactoryOperations.selectFrom(Table<R> table) Create a new DSL select statement Example: SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
void	LockProvider.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 TableRecord<R>> Truncate<R>	FactoryOperations.truncate(Table<R> table) Create a new DSL truncate statement.
<R extends Record> UpdateSetStep<R>	FactoryOperations.update(Table<R> table) Create a new DSL update statement.
<R extends Record> UpdateQuery<R>	FactoryOperations.updateQuery(Table<R> table) Create a new UpdateQuery

Uses of Table in org.jooq.impl

Classes in org.jooq.impl that implement Table

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.
class	UpdatableTableImpl<R extends Record> A table implementation for a table holding a primary key This type is for JOOQ INTERNAL USE only.

Methods in org.jooq.impl that return Table

Table<R>	TableImpl.as(String as) Subclasses may override this method to provide custom aliasing implementations Get an aliased QueryPart.
Table<R>	TableRecordImpl.getTable()
Table<R>	CustomRecord.getTable()
Table<?>	SchemaImpl.getTable(String name)
static Table<?>	Factory.table(ArrayRecord<?> array) A synonym for Factory.unnest(ArrayRecord)
static Table<?>	Factory.table(Field<?> cursor) A synonym for Factory.unnest(Field)
static Table<?>	Factory.table(List<?> list) A synonym for Factory.unnest(List)
static Table<?>	Factory.table(Object[] array) A synonym for Factory.unnest(Object[])
static <R extends Record> Table<R>	Factory.table(Select<R> select) A synonym for TableLike.asTable().
static Table<Record>	Factory.table(String sql) A PlainSQLTable is a table that can contain user-defined plain SQL, because sometimes it is easier to express things directly in SQL, for instance complex, but static subqueries or tables from different schemas.
static Table<Record>	Factory.table(String sql, Object... bindings) A PlainSQLTable is a table that can contain user-defined plain SQL, because sometimes it is easier to express things directly in SQL, for instance complex, but static subqueries or tables from different schemas.
static Table<?>	Factory.unnest(ArrayRecord<?> array) Create a table from an array of values This wraps the argument array in a TABLE function for Oracle.
static Table<?>	Factory.unnest(Field<?> cursor) Create a table from a field.
static Table<?>	Factory.unnest(List<?> list) Create a table from a list of values This is equivalent to the TABLE function for H2, or the UNNEST function in HSQLDB and Postgres For Oracle, use Factory.table(ArrayRecord) instead, as Oracle knows only typed arrays In all other dialects, unnesting of arrays is simulated using several UNION ALL connected subqueries.
static Table<?>	Factory.unnest(Object[] array) Create a table from an array of values This is equivalent to the TABLE function for H2, or the UNNEST function in HSQLDB and Postgres For Oracle, use Factory.table(ArrayRecord) instead, as Oracle knows only typed arrays In all other dialects, unnesting of arrays is simulated using several UNION ALL connected subqueries.

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

List<Table<?>>

SchemaImpl.getTables() List all tables contained in this schema

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

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
<R extends Record> DeleteWhereStep<R>	Factory.delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> DeleteQuery<R>	Factory.deleteQuery(Table<R> table) Create a new DeleteQuery
<R extends TableRecord<R>> int	Factory.executeDelete(Table<R> table) Delete records from a table DELETE FROM [table]
<R extends TableRecord<R>,T> int	Factory.executeDelete(Table<R> table, Condition condition) Delete records from a table DELETE FROM [table] WHERE [condition]
<R extends TableRecord<R>> int	Factory.executeDeleteOne(Table<R> table) Delete one record in a table DELETE FROM [table]
<R extends TableRecord<R>,T> int	Factory.executeDeleteOne(Table<R> table, Condition condition) Delete one record in a table DELETE FROM [table] WHERE [condition]
<R extends TableRecord<R>> int	Factory.executeInsert(Table<R> table, R record) Insert one record INSERT INTO [table] ...
<R extends TableRecord<R>> int	Factory.executeUpdate(Table<R> table, R record) Update a table UPDATE [table] SET [modified values in record]
<R extends TableRecord<R>,T> int	Factory.executeUpdate(Table<R> table, R record, Condition condition) Update a table UPDATE [table] SET [modified values in record] WHERE [condition]
<R extends TableRecord<R>> int	Factory.executeUpdateOne(Table<R> table, R record) Update one record in a table UPDATE [table] SET [modified values in record]
<R extends TableRecord<R>,T> int	Factory.executeUpdateOne(Table<R> table, R record, Condition condition) Update one record in a table UPDATE [table] SET [modified values in record] WHERE [condition]
<R extends Record> Result<R>	Factory.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table]
<R extends Record> Result<R>	Factory.fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition]
<R extends Record> R	Factory.fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] LIMIT 1
<R extends Record> R	Factory.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table]
<R extends Record> R	Factory.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition]
<O extends Record> List<ForeignKey<O,R>>	UpdatableTableImpl.getReferencesFrom(Table<O> other)
<R extends Record> InsertSetStep<R>	Factory.insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	Factory.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	Factory.insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record> Insert<R>	Factory.insertInto(Table<R> into, Select<?> select) Deprecated.
<R extends Record> InsertQuery<R>	Factory.insertQuery(Table<R> into) Create a new InsertQuery
<R extends TableRecord<R>> LoaderOptionsStep<R>	Factory.loadInto(Table<R> table) Create a new Loader object to load data from a CSV or XML source
<R extends Record> MergeUsingStep<R>	Factory.mergeInto(Table<R> table) Create a new DSL merge statement.
<R extends TableRecord<R>> R	Factory.newRecord(Table<R> table) Create a new Record that can be inserted into the corresponding table.
<R extends TableRecord<R>> R	Factory.newRecord(Table<R> table, Object source) Create a new pre-filled Record that can be inserted into the corresponding table.
<R extends Record> SimpleSelectWhereStep<R>	Factory.selectFrom(Table<R> table) Create a new DSL select statement Example: SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
<R extends TableRecord<R>> Truncate<R>	Factory.truncate(Table<R> table) Create a new DSL truncate statement.
<R extends Record> UpdateSetStep<R>	Factory.update(Table<R> table) Create a new DSL update statement.
<R extends Record> UpdateQuery<R>	Factory.updateQuery(Table<R> table) Create a new UpdateQuery

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

CustomRecord(Table<R> table)

TableImpl(String name, Schema schema, Table<R> aliased)

TableRecordImpl(Table<R> table)

UpdatableTableImpl(String name, Schema schema, Table<R> aliased)