jOOQ 3.18.7 · org.jooq.impl.AbstractTable

Modifier and Type	Field and Description
private static final Clause[]	CLAUSES Deprecated as a consequence of `Clause` being deprecated.
private transient Row	fieldsRow
private transient Identity<R, ?>	identity
private static final JooqLogger	log Hides org.jooq.impl.AbstractQueryPart.log.
private final TableOptions	options
private Schema	tableschema
private transient DataType<R>	tabletype

Access	Constructor and Description
pack-priv	AbstractTable(TableOptions options, Name name)
pack-priv	AbstractTable(TableOptions options, Name name, Schema schema)
pack-priv	AbstractTable(TableOptions options, Name name, Schema schema, Comment comment)

Method Summary

Modifier and Type	Method and Description
public Name	$alias() Implements org.jooq.impl.QOM.Aliasable.$alias. The alias if any.
public Table<R>	$aliased() Implements org.jooq.impl.QOM.Aliasable.$aliased. The aliased part (a `Field` or a `Table`).
public final DataType<R>	$dataType() Implements org.jooq.Typed.$dataType. Experimental query object model accessor method, see also `QOM`.
public final Schema	$schema() Implements org.jooq.Qualified.$schema. Experimental query object model accessor method, see also `QOM`.
public final SelectField<R>	as(Field<?> The other field whose name this field is aliased with. otherField) Implements org.jooq.SelectField.as. Deprecated as a consequence of `Field` being deprecated. Create an alias for this field based on another field's name.
public Table<R>	as(String The alias name alias) Implements org.jooq.Table.as. Create an alias for this table.
public final Table<R>	as(String The alias name alias, String... The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names. fieldAliases) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(String The alias name alias, Collection<? extends String> The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names. fieldAliases) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(String The alias name alias, Function<? super Field<?>, ? extends String> The function providing field aliases. aliasFunction) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(String The alias name alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> The function providing field aliases. aliasFunction) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public Table<R>	as(Name The alias name alias) Implements org.jooq.Table.as. Create an alias for this table.
public Table<R>	as(Name The alias name alias, Name... The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names. fieldAliases) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(Name The alias name alias, Collection<? extends Name> The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names. fieldAliases) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(Name The alias name alias, Function<? super Field<?>, ? extends Name> The function providing field aliases. aliasFunction) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(Name The alias name alias, BiFunction<? super Field<?>, ? super Integer, ? extends Name> The function providing field aliases. aliasFunction) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public Table<R>	as(Table<?> The other table whose name this table is aliased with. otherTable) Implements org.jooq.Table.as. Create an alias for this table based on another table's name.
public final Table<R>	as(Table<?> The other table whose name this table is aliased with. otherTable, Field<?>... The other fields whose field name this table's fields are aliased with. otherFields) Implements org.jooq.Table.as. Deprecated as a consequence of `Field` being deprecated. Create an alias for this table based on another table's name.
public final Table<R>	as(Table<?> The other table whose name this table is aliased with. otherTable, Collection<? extends Field<?>> The other fields whose field name this table's fields are aliased with. otherFields) Implements org.jooq.Table.as. Create an alias for this table based on another table's name.
public final Table<R>	as(Table<?> The other table whose name is used as alias name otherTable, Function<? super Field<?>, ? extends Field<?>> The function providing field aliases. aliasFunction) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Table<R>	as(Table<?> The other table whose name is used as alias name otherTable, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>> The function providing field aliases. aliasFunction) Implements org.jooq.Table.as. Create an alias for this table and its fields.
public final Field<Result<R>>	asMultiset() Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Field<Result<R>>	asMultiset(String alias) Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Field<Result<R>>	asMultiset(Name alias) Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Field<Result<R>>	asMultiset(Field<?> alias) Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Table<R>	asTable() Implements org.jooq.TableLike.asTable. The underlying table representation of this object.
public final Table<R>	asTable(String alias) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, String... fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, Collection<? extends String> fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Name alias) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Name alias, Name... fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Name alias, Collection<? extends Name> fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Table<?> alias) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Table<?> alias, Field<?>... fieldAliases) Implements org.jooq.TableLike.asTable. Deprecated as a consequence of `Field` being deprecated. The underlying aliased table representation of this object.
public final Table<R>	asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, Function<? super Field<?>, ? extends String> aliasFunction) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> aliasFunction) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final QualifiedAsterisk	asterisk() Implements org.jooq.Table.asterisk. Create a qualified asterisk expression from this table (`table.*`) for use with `SELECT`.
public Clause[]	clauses(Context<?> ctx) Overrides org.jooq.impl.AbstractQueryPart.clauses. Implements org.jooq.QueryPartInternal.clauses. Deprecated as a consequence of `Clause` being deprecated. The `Clause`s that are represented by this query part.
public final <U> SelectField<U>	convert(Binding<R, U> The binding to be applied on any operations using this field. binding) Implements org.jooq.SelectField.convert. Apply an ad-hoc data type `Binding` to this field expression.
public final <U> SelectField<U>	convert(Converter<R, U> The converter to be applied on any operations using this field. converter) Implements org.jooq.SelectField.convert. Apply an ad-hoc data type `Converter` to this field expression.
public final <U> SelectField<U>	convert(Class<U> The converter to be applied on any operations using this field. toType, Function<? super R, ? extends U> from, Function<? super U, ? extends R> to) Implements org.jooq.SelectField.convert. Apply an ad-hoc data type `Converter` to this field expression.
public final <U> SelectField<U>	convertFrom(Class<U> The read-only converter to be applied on any operations using this field. toType, Function<? super R, ? extends U> from) Implements org.jooq.SelectField.convertFrom. Apply an ad-hoc read-only data type `Converter` to this field expression.
public final <U> SelectField<U>	convertFrom(Function<? super R, ? extends U> The read-only converter to be applied on any operations using this field. from) Implements org.jooq.SelectField.convertFrom. Apply an ad-hoc read-only data type `Converter` to this field expression.
public final <U> SelectField<U>	convertTo(Class<U> The write-only converter to be applied on any operations using this field. toType, Function<? super U, ? extends R> to) Implements org.jooq.SelectField.convertTo. Apply an ad-hoc write-only data type `Converter` to this field expression.
public final <U> SelectField<U>	convertTo(Function<? super U, ? extends R> The write-only converter to be applied on any operations using this field. to) Implements org.jooq.SelectField.convertTo. Apply an ad-hoc write-only data type `Converter` to this field expression.
protected static final <R extends Record, T> TableField<R, T>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table) Deprecated - 3.12.0 - [#8000] - Use `AbstractTable#createField(Name, DataType, Table)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T> TableField<R, T>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment) Deprecated - 3.12.0 - [#8000] - Use `AbstractTable#createField(Name, DataType, Table, String)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T, U> TableField<R, U>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment, Converter<T, U> converter) Deprecated - 3.12.0 - [#8000] - Use `AbstractTable#createField(Name, DataType, Table, String, Converter)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T, U> TableField<R, U>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment, Binding<T, U> binding) Deprecated - 3.12.0 - [#8000] - Use `AbstractTable#createField(Name, DataType, Table, String, Binding)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T, X, U> TableField<R, U>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment, Converter<X, U> converter, Binding<T, X> binding) Deprecated - 3.12.0 - [#8000] - Use `AbstractTable#createField(Name, DataType, Table, String, Converter, Binding)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T> TableField<R, T>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type) Deprecated - 3.12.0 - [#8000] - Use `createField(Name, DataType)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T> TableField<R, T>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment) Deprecated - 3.12.0 - [#8000] - Use `createField(Name, DataType, String)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T, U> TableField<R, U>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment, Converter<T, U> converter) Deprecated - 3.12.0 - [#8000] - Use `createField(Name, DataType, String, Converter)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T, U> TableField<R, U>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment, Binding<T, U> binding) Deprecated - 3.12.0 - [#8000] - Use `createField(Name, DataType, String, Binding)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T, X, U> TableField<R, U>	createField(String The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment, Converter<X, U> converter, Binding<T, X> binding) Deprecated - 3.12.0 - [#8000] - Use `createField(Name, DataType, String, Converter, Binding)` instead. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T> TableField<R, T>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T> TableField<R, T>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment, Converter<T, U> converter) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment, Binding<T, U> binding) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, T, X, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, Table<R> table, String comment, Converter<X, U> converter, Binding<T, X> binding) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, TR extends Table<R>, T> TableField<R, T>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Generator<R, TR, T> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, TR extends Table<R>, T, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Converter<T, U> converter, Generator<R, TR, U> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, TR extends Table<R>, T, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Binding<T, U> binding, Generator<R, TR, U> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected static final <R extends Record, TR extends Table<R>, T, X, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Converter<X, U> converter, Binding<T, X> binding, Generator<R, TR, U> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T> TableField<R, T>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T> TableField<R, T>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment, Converter<T, U> converter) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment, Binding<T, U> binding) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <T, X, U> TableField<R, U>	createField(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, String comment, Converter<X, U> converter, Binding<T, X> binding) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <TR extends Table<R>, T> TableField<R, T>	createField0(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Generator<R, TR, T> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <TR extends Table<R>, T, U> TableField<R, U>	createField0(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Converter<T, U> converter, Generator<R, TR, U> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <TR extends Table<R>, T, U> TableField<R, U>	createField0(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Binding<T, U> binding, Generator<R, TR, U> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
protected final <TR extends Table<R>, T, X, U> TableField<R, U>	createField0(Name The name of the field (case-sensitive!) name, DataType<T> The data type of the field type, TR table, String comment, Converter<X, U> converter, Binding<T, X> binding, Generator<R, TR, U> generator) Deprecated as a consequence of `TableField` being deprecated. Subclasses may call this method to create `TableField` objects that are linked to this table.
public final Table<Record>	crossApply(TableLike<?> table) Implements org.jooq.Table.crossApply. `CROSS APPLY` a table to this table.
public final Table<Record>	crossApply(SQL sql) Implements org.jooq.Table.crossApply. `CROSS APPLY` a table to this table.
public final Table<Record>	crossApply(String sql) Implements org.jooq.Table.crossApply. `CROSS APPLY` a table to this table.
public final Table<Record>	crossApply(String sql, Object... bindings) Implements org.jooq.Table.crossApply. `CROSS APPLY` a table to this table.
public final Table<Record>	crossApply(String sql, QueryPart... parts) Implements org.jooq.Table.crossApply. `CROSS APPLY` a table to this table.
public final Table<Record>	crossApply(Name name) Implements org.jooq.Table.crossApply. `CROSS APPLY` a table to this table.
public final Table<Record>	crossJoin(TableLike<?> table) Implements org.jooq.Table.crossJoin. `CROSS JOIN` a table to this table.
public final Table<Record>	crossJoin(SQL sql) Implements org.jooq.Table.crossJoin. `CROSS JOIN` a table to this table.
public final Table<Record>	crossJoin(String sql) Implements org.jooq.Table.crossJoin. `CROSS JOIN` a table to this table.
public final Table<Record>	crossJoin(String sql, Object... bindings) Implements org.jooq.Table.crossJoin. `CROSS JOIN` a table to this table.
public final Table<Record>	crossJoin(String sql, QueryPart... parts) Implements org.jooq.Table.crossJoin. `CROSS JOIN` a table to this table.
public final Table<Record>	crossJoin(Name name) Implements org.jooq.Table.crossJoin. `CROSS JOIN` a table to this table.
public final DivideByOnStep	divideBy(Table<?> divisor) Implements org.jooq.Table.divideBy. Create a new `TABLE` reference from this table, applying relational division.
public final Condition	eq(Table<R> arg2) Implements org.jooq.Table.eq. Deprecated as a consequence of `Condition` being deprecated. The `EQ` operator.
public final Condition	equal(Table<R> arg2) Implements org.jooq.Table.equal. Deprecated as a consequence of `Condition` being deprecated. The `EQUAL` operator, an alias for the `EQ` operator.
public final Field<?>[]	fields() Overrides default org.jooq.impl.FieldsTrait.fields. Implements org.jooq.Fields.fields. Deprecated as a consequence of `Field` being deprecated. Get all fields known to this type.
pack-priv abstract FieldsImpl<R>	fields0() Subclasses should override this method to provide the set of fields contained in the concrete table implementation.
public Row	fieldsRow() Implements org.jooq.Fields.fieldsRow. Get all fields known to this type as a `Row`.
public final Table<R>	forceIndex(String... indexes) Implements org.jooq.Table.forceIndex. Specify a MySQL style table hint for query optimisation.
public final Table<R>	forceIndexForGroupBy(String... indexes) Implements org.jooq.Table.forceIndexForGroupBy. Specify a MySQL style table hint for query optimisation.
public final Table<R>	forceIndexForJoin(String... indexes) Implements org.jooq.Table.forceIndexForJoin. Specify a MySQL style table hint for query optimisation.
public final Table<R>	forceIndexForOrderBy(String... indexes) Implements org.jooq.Table.forceIndexForOrderBy. Specify a MySQL style table hint for query optimisation.
public final R	from(Record record) Implements org.jooq.Table.from. The inverse operation of `Record#into(Table)`.
public final TablePartitionByStep<Record>	fullJoin(TableLike<?> table) Implements org.jooq.Table.fullJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullJoin(SQL sql) Implements org.jooq.Table.fullJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullJoin(String sql) Implements org.jooq.Table.fullJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullJoin(String sql, Object... bindings) Implements org.jooq.Table.fullJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullJoin(String sql, QueryPart... parts) Implements org.jooq.Table.fullJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullJoin(Name name) Implements org.jooq.Table.fullJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullOuterJoin(TableLike<?> table) Implements org.jooq.Table.fullOuterJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullOuterJoin(SQL sql) Implements org.jooq.Table.fullOuterJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullOuterJoin(String sql) Implements org.jooq.Table.fullOuterJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullOuterJoin(String sql, Object... bindings) Implements org.jooq.Table.fullOuterJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullOuterJoin(String sql, QueryPart... parts) Implements org.jooq.Table.fullOuterJoin. `FULL OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	fullOuterJoin(Name name) Implements org.jooq.Table.fullOuterJoin. `FULL OUTER JOIN` a table to this table.
public final Binding<?, R>	getBinding() Implements org.jooq.Typed.getBinding. The object's underlying `Binding`.
public final Catalog	getCatalog() Implements org.jooq.Qualified.getCatalog. Get the object's catalog.
public List<Check<R>>	getChecks() Implements org.jooq.Table.getChecks. Get a list of `CHECK` constraints of this table.
public final ContextConverter<?, R>	getConverter() Implements org.jooq.Typed.getConverter. The object's underlying `Converter`.
public final DataType<R>	getDataType(Configuration configuration) Implements org.jooq.Typed.getDataType. The dialect-specific type of this object.
public final DataType<R>	getDataType() Implements org.jooq.RecordQualifier.getDataType, org.jooq.Typed.getDataType. The `UDT`'s or `Table`'s data type as known to the database.
public Identity<R, ?>	getIdentity() Implements org.jooq.Table.getIdentity. Retrieve the table's `IDENTITY` information, if available.
public List<Index>	getIndexes() Implements org.jooq.Table.getIndexes. Retrieve all of the table's indexes.
public List<UniqueKey<R>>	getKeys() Implements org.jooq.Table.getKeys. Retrieve all of the table's primary and unique keys.
public final TableOptions	getOptions() Implements org.jooq.Table.getOptions. Get the table options.
public final Package	getPackage() Implements org.jooq.RecordQualifier.getPackage. Get the UDT package if this is a `UDT`, or `null` if it is not a UDT, or if it is a schema level UDT defined outside of a package.
public UniqueKey<R>	getPrimaryKey() Implements org.jooq.Table.getPrimaryKey. Retrieve the table's primary key Subclasses may override this method
public TableField<R, ?>	getRecordTimestamp() Implements org.jooq.Table.getRecordTimestamp. Deprecated as a consequence of `TableField` being deprecated. A "timestamp" field holding record timestamp information used for optimistic locking jOOQ supports optimistic locking in `UpdatableRecord#store()` and `UpdatableRecord#delete()` if `Settings#isExecuteWithOptimisticLocking()` is enabled.
public TableField<R, ?>	getRecordVersion() Implements org.jooq.Table.getRecordVersion. Deprecated as a consequence of `TableField` being deprecated. A "version" field holding record version information used for optimistic locking jOOQ supports optimistic locking in `UpdatableRecord#store()` and `UpdatableRecord#delete()` if `Settings#isExecuteWithOptimisticLocking()` is enabled.
public List<ForeignKey<R, ?>>	getReferences() Implements org.jooq.Table.getReferences. Get the list of `FOREIGN KEY`'s of this table Subclasses should override this method
public final <O extends Record> List<ForeignKey<O, R>>	getReferencesFrom(Table<O> The other table of the foreign key relationship other) Implements org.jooq.Table.getReferencesFrom. Get a list of `FOREIGN KEY`'s of a specific table, referencing a this table.
public final <O extends Record> List<ForeignKey<R, O>>	getReferencesTo(Table<O> The other table of the foreign key relationship other) Implements org.jooq.Table.getReferencesTo. Get a list of `FOREIGN KEY`'s of this table, referencing a specific table.
public Schema	getSchema() Implements org.jooq.Qualified.getSchema. Get the object's schema.
public final TableOptions.TableType	getTableType() Implements org.jooq.Table.getTableType. Get the table type.
public final Class<R>	getType() Implements org.jooq.Typed.getType. The Java type of the object.
public List<UniqueKey<R>>	getUniqueKeys() Implements org.jooq.Table.getUniqueKeys. Retrieve all of the table's unique keys.
public final Table<R>	ignoreIndex(String... indexes) Implements org.jooq.Table.ignoreIndex. Specify a MySQL style table hint for query optimisation.
public final Table<R>	ignoreIndexForGroupBy(String... indexes) Implements org.jooq.Table.ignoreIndexForGroupBy. Specify a MySQL style table hint for query optimisation.
public final Table<R>	ignoreIndexForJoin(String... indexes) Implements org.jooq.Table.ignoreIndexForJoin. Specify a MySQL style table hint for query optimisation.
public final Table<R>	ignoreIndexForOrderBy(String... indexes) Implements org.jooq.Table.ignoreIndexForOrderBy. Specify a MySQL style table hint for query optimisation.
public final TableOnStep<Record>	innerJoin(TableLike<?> table) Implements org.jooq.Table.innerJoin. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	innerJoin(SQL sql) Implements org.jooq.Table.innerJoin. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	innerJoin(String sql) Implements org.jooq.Table.innerJoin. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	innerJoin(String sql, Object... bindings) Implements org.jooq.Table.innerJoin. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	innerJoin(String sql, QueryPart... parts) Implements org.jooq.Table.innerJoin. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	innerJoin(Name name) Implements org.jooq.Table.innerJoin. `INNER JOIN` a table to this table.
public TableOptionalOnStep<Record>	join(TableLike<?> table, JoinType type) Implements org.jooq.Table.join. Join a table to this table using a `JoinType` Depending on the `JoinType`, a subsequent `TableOnStep#on(Condition)` or `TableOnStep#using(Field...)` clause is required.
public final TableOnStep<Record>	join(TableLike<?> table) Implements org.jooq.Table.join. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	join(SQL sql) Implements org.jooq.Table.join. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	join(String sql) Implements org.jooq.Table.join. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	join(String sql, Object... bindings) Implements org.jooq.Table.join. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	join(String sql, QueryPart... parts) Implements org.jooq.Table.join. `INNER JOIN` a table to this table.
public final TableOnStep<Record>	join(Name name) Implements org.jooq.Table.join. `INNER JOIN` a table to this table.
public final TableOnStep<R>	leftAntiJoin(TableLike<?> table) Implements org.jooq.Table.leftAntiJoin. A synthetic `LEFT ANTI JOIN` clause that translates to an equivalent `NOT EXISTS` predicate.
public final TablePartitionByStep<Record>	leftJoin(TableLike<?> table) Implements org.jooq.Table.leftJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftJoin(SQL sql) Implements org.jooq.Table.leftJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftJoin(String sql) Implements org.jooq.Table.leftJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftJoin(String sql, Object... bindings) Implements org.jooq.Table.leftJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftJoin(String sql, QueryPart... parts) Implements org.jooq.Table.leftJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftJoin(Name name) Implements org.jooq.Table.leftJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftOuterJoin(TableLike<?> table) Implements org.jooq.Table.leftOuterJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftOuterJoin(SQL sql) Implements org.jooq.Table.leftOuterJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftOuterJoin(String sql) Implements org.jooq.Table.leftOuterJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftOuterJoin(String sql, Object... bindings) Implements org.jooq.Table.leftOuterJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftOuterJoin(String sql, QueryPart... parts) Implements org.jooq.Table.leftOuterJoin. `LEFT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	leftOuterJoin(Name name) Implements org.jooq.Table.leftOuterJoin. `LEFT OUTER JOIN` a table to this table.
public final TableOnStep<R>	leftSemiJoin(TableLike<?> table) Implements org.jooq.Table.leftSemiJoin. A synthetic `LEFT SEMI JOIN` clause that translates to an equivalent `EXISTS` predicate.
public final Table<Record>	naturalFullOuterJoin(TableLike<?> table) Implements org.jooq.Table.naturalFullOuterJoin. `NATURAL FULL OUTER JOIN` a table to this table.
public final Table<Record>	naturalFullOuterJoin(SQL sql) Implements org.jooq.Table.naturalFullOuterJoin. `NATURAL FULL OUTER JOIN` a table to this table.
public final Table<Record>	naturalFullOuterJoin(String sql) Implements org.jooq.Table.naturalFullOuterJoin. `NATURAL FULL OUTER JOIN` a table to this table.
public final Table<Record>	naturalFullOuterJoin(String sql, Object... bindings) Implements org.jooq.Table.naturalFullOuterJoin. `NATURAL FULL OUTER JOIN` a table to this table.
public final Table<Record>	naturalFullOuterJoin(String sql, QueryPart... parts) Implements org.jooq.Table.naturalFullOuterJoin. `NATURAL FULL OUTER JOIN` a table to this table.
public final Table<Record>	naturalFullOuterJoin(Name name) Implements org.jooq.Table.naturalFullOuterJoin. `NATURAL FULL OUTER JOIN` a table to this table.
public final Table<Record>	naturalJoin(TableLike<?> table) Implements org.jooq.Table.naturalJoin. `NATURAL JOIN` a table to this table.
public final Table<Record>	naturalJoin(SQL sql) Implements org.jooq.Table.naturalJoin. `NATURAL JOIN` a table to this table.
public final Table<Record>	naturalJoin(String sql) Implements org.jooq.Table.naturalJoin. `NATURAL JOIN` a table to this table.
public final Table<Record>	naturalJoin(String sql, Object... bindings) Implements org.jooq.Table.naturalJoin. `NATURAL JOIN` a table to this table.
public final Table<Record>	naturalJoin(String sql, QueryPart... parts) Implements org.jooq.Table.naturalJoin. `NATURAL JOIN` a table to this table.
public final Table<Record>	naturalJoin(Name name) Implements org.jooq.Table.naturalJoin. `NATURAL JOIN` a table to this table.
public final Table<Record>	naturalLeftOuterJoin(TableLike<?> table) Implements org.jooq.Table.naturalLeftOuterJoin. `NATURAL LEFT OUTER JOIN` a table to this table.
public final Table<Record>	naturalLeftOuterJoin(SQL sql) Implements org.jooq.Table.naturalLeftOuterJoin. `NATURAL LEFT OUTER JOIN` a table to this table.
public final Table<Record>	naturalLeftOuterJoin(String sql) Implements org.jooq.Table.naturalLeftOuterJoin. `NATURAL LEFT OUTER JOIN` a table to this table.
public final Table<Record>	naturalLeftOuterJoin(String sql, Object... bindings) Implements org.jooq.Table.naturalLeftOuterJoin. `NATURAL LEFT OUTER JOIN` a table to this table.
public final Table<Record>	naturalLeftOuterJoin(String sql, QueryPart... parts) Implements org.jooq.Table.naturalLeftOuterJoin. `NATURAL LEFT OUTER JOIN` a table to this table.
public final Table<Record>	naturalLeftOuterJoin(Name name) Implements org.jooq.Table.naturalLeftOuterJoin. `NATURAL LEFT OUTER JOIN` a table to this table.
public final Table<Record>	naturalRightOuterJoin(TableLike<?> table) Implements org.jooq.Table.naturalRightOuterJoin. `NATURAL RIGHT OUTER JOIN` a table to this table.
public final Table<Record>	naturalRightOuterJoin(SQL sql) Implements org.jooq.Table.naturalRightOuterJoin. `NATURAL RIGHT OUTER JOIN` a table to this table.
public final Table<Record>	naturalRightOuterJoin(String sql) Implements org.jooq.Table.naturalRightOuterJoin. `NATURAL RIGHT OUTER JOIN` a table to this table.
public final Table<Record>	naturalRightOuterJoin(String sql, Object... bindings) Implements org.jooq.Table.naturalRightOuterJoin. `NATURAL RIGHT OUTER JOIN` a table to this table.
public final Table<Record>	naturalRightOuterJoin(String sql, QueryPart... parts) Implements org.jooq.Table.naturalRightOuterJoin. `NATURAL RIGHT OUTER JOIN` a table to this table.
public final Table<Record>	naturalRightOuterJoin(Name name) Implements org.jooq.Table.naturalRightOuterJoin. `NATURAL RIGHT OUTER JOIN` a table to this table.
public final Condition	ne(Table<R> arg2) Implements org.jooq.Table.ne. Deprecated as a consequence of `Condition` being deprecated. The `NE` operator.
public final R	newRecord() Implements org.jooq.RecordQualifier.newRecord. Create a new `Record` of this `UDT`'s or `Table`'s type.
public final Condition	notEqual(Table<R> arg2) Implements org.jooq.Table.notEqual. Deprecated as a consequence of `Condition` being deprecated. The `NOT_EQUAL` operator, an alias for the `NE` operator.
public final Table<Record>	outerApply(TableLike<?> table) Implements org.jooq.Table.outerApply. `OUTER APPLY` a table to this table.
public final Table<Record>	outerApply(SQL sql) Implements org.jooq.Table.outerApply. `OUTER APPLY` a table to this table.
public final Table<Record>	outerApply(String sql) Implements org.jooq.Table.outerApply. `OUTER APPLY` a table to this table.
public final Table<Record>	outerApply(String sql, Object... bindings) Implements org.jooq.Table.outerApply. `OUTER APPLY` a table to this table.
public final Table<Record>	outerApply(String sql, QueryPart... parts) Implements org.jooq.Table.outerApply. `OUTER APPLY` a table to this table.
public final Table<Record>	outerApply(Name name) Implements org.jooq.Table.outerApply. `OUTER APPLY` a table to this table.
public final RecordType<R>	recordType() Implements org.jooq.Table.recordType. The record type produced by this table.
public final TablePartitionByStep<Record>	rightJoin(TableLike<?> table) Implements org.jooq.Table.rightJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightJoin(SQL sql) Implements org.jooq.Table.rightJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightJoin(String sql) Implements org.jooq.Table.rightJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightJoin(String sql, Object... bindings) Implements org.jooq.Table.rightJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightJoin(String sql, QueryPart... parts) Implements org.jooq.Table.rightJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightJoin(Name name) Implements org.jooq.Table.rightJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightOuterJoin(TableLike<?> table) Implements org.jooq.Table.rightOuterJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightOuterJoin(SQL sql) Implements org.jooq.Table.rightOuterJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightOuterJoin(String sql) Implements org.jooq.Table.rightOuterJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightOuterJoin(String sql, Object... bindings) Implements org.jooq.Table.rightOuterJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightOuterJoin(String sql, QueryPart... parts) Implements org.jooq.Table.rightOuterJoin. `RIGHT OUTER JOIN` a table to this table.
public final TablePartitionByStep<Record>	rightOuterJoin(Name name) Implements org.jooq.Table.rightOuterJoin. `RIGHT OUTER JOIN` a table to this table.
public Field<RowId>	rowid() Implements org.jooq.Table.rowid. Deprecated as a consequence of `Field` being deprecated. The `ROWID` operator.
public final TableOptionalOnStep<Record>	straightJoin(TableLike<?> table) Implements org.jooq.Table.straightJoin. `STRAIGHT_JOIN` a table to this table.
public final TableOptionalOnStep<Record>	straightJoin(SQL sql) Implements org.jooq.Table.straightJoin. `STRAIGHT_JOIN` a table to this table.
public final TableOptionalOnStep<Record>	straightJoin(String sql) Implements org.jooq.Table.straightJoin. `STRAIGHT_JOIN` a table to this table.
public final TableOptionalOnStep<Record>	straightJoin(String sql, Object... bindings) Implements org.jooq.Table.straightJoin. `STRAIGHT_JOIN` a table to this table.
public final TableOptionalOnStep<Record>	straightJoin(String sql, QueryPart... parts) Implements org.jooq.Table.straightJoin. `STRAIGHT_JOIN` a table to this table.
public final TableOptionalOnStep<Record>	straightJoin(Name name) Implements org.jooq.Table.straightJoin. `STRAIGHT_JOIN` a table to this table.
pack-priv final TableAsField<R>	tf() Deprecated as a consequence of `TableAsField` being deprecated.
public final Table<R>	useIndex(String... indexes) Implements org.jooq.Table.useIndex. Specify a MySQL style table hint for query optimisation.
public final Table<R>	useIndexForGroupBy(String... indexes) Implements org.jooq.Table.useIndexForGroupBy. Specify a MySQL style table hint for query optimisation.
public final Table<R>	useIndexForJoin(String... indexes) Implements org.jooq.Table.useIndexForJoin. Specify a MySQL style table hint for query optimisation.
public final Table<R>	useIndexForOrderBy(String... indexes) Implements org.jooq.Table.useIndexForOrderBy. Specify a MySQL style table hint for query optimisation.
public Table<R>	where(Condition condition) Implements org.jooq.Table.where. Deprecated as a consequence of `Condition` being deprecated. Add a `WHERE` clause to the table, connecting them with each other with `Operator#AND`.
public Table<R>	where(Condition... conditions) Implements org.jooq.Table.where. Deprecated as a consequence of `Condition` being deprecated. Add a `WHERE` clause to the table, connecting them with each other with `Operator#AND`.
public Table<R>	where(Collection<? extends Condition> conditions) Implements org.jooq.Table.where. Add a `WHERE` clause to the table, connecting them with each other with `Operator#AND`.
public Table<R>	where(Field<Boolean> field) Implements org.jooq.Table.where. Deprecated as a consequence of `Field` being deprecated. Add a `WHERE` clause to the table.
public Table<R>	where(SQL sql) Implements org.jooq.Table.where. Add a `WHERE` clause to the table.
public Table<R>	where(String sql) Implements org.jooq.Table.where. Add a `WHERE` clause to the table.
public Table<R>	where(String sql, Object... bindings) Implements org.jooq.Table.where. Add a `WHERE` clause to the table.
public Table<R>	where(String sql, QueryPart... parts) Implements org.jooq.Table.where. Add a `WHERE` clause to the table.
public Table<R>	whereExists(Select<?> select) Implements org.jooq.Table.whereExists. Add a `WHERE EXISTS` clause to the table.
public Table<R>	whereNotExists(Select<?> select) Implements org.jooq.Table.whereNotExists. Add a `WHERE NOT EXISTS` clause to the table.
public final Table<Record>	withOrdinality() Implements org.jooq.Table.withOrdinality. Add the `WITH ORDINALITY` clause.

Inherited from org.jooq.impl.AbstractNamed:: $name equals find find findAll findAll findIgnoreCase findIgnoreCase getComment getCommentPart getName getQualifiedName getUnqualifiedName hashCode nameOrDefault qualify

pack-priv abstract Class AbstractTable<R extends org.jooq.Record>

Field Summary

Constructor Summary

Method Summary