CustomTable (jOOQ 3.5.0 API)

java.lang.Object
- org.jooq.impl.TableImpl<R>
- - org.jooq.impl.CustomTable<R>

All Implemented Interfaces:

java.io.Serializable, QueryPart, QueryPartInternal, Table<R>, TableLike<R>
```
public abstract class CustomTable<R extends TableRecord<R>>
extends TableImpl<R>
```
A base class for custom Table implementations in client code.
Client code may provide proper Table implementations extending this useful base class. All necessary parts of the Table interface are already implemented. Only this method needs further implementation:
- getRecordType()
Refer to this method's Javadoc for further details about its expected behaviour.
Use this base class when providing custom tables to any of the following methods:
Author:

Lukas Eder

See Also:

Serialized Form

Field Summary
- Fields inherited from class org.jooq.impl.TableImpl
  parameters

Constructor Summary

Constructors
Modifier Constructor and Description

protected CustomTable(java.lang.String name)

protected CustomTable(java.lang.String name, Schema schema)

Constructors
Modifier	Constructor and Description
`protected`	`CustomTable(java.lang.String name)`
`protected`	`CustomTable(java.lang.String name, Schema schema)`

Method Summary

All Methods Static Methods Instance Methods Abstract Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`Table<R>`	`asOfScn(Field<? extends java.lang.Number> scn)` Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asOfScn(java.lang.Number scn)` Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asOfTimestamp(Field<java.sql.Timestamp> timestamp)` Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asOfTimestamp(java.sql.Timestamp timestamp)` Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`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>`	`asTable(java.lang.String alias)` The underlying aliased table representation of this object
`Table<R>`	`asTable(java.lang.String alias, java.lang.String... fieldAliases)` The underlying aliased table representation of this object
`void`	`bind(BindContext ctx)` Deprecated.
`protected DSLContext`	`create()` Internal convenience method
`protected DSLContext`	`create(Configuration configuration)` Internal convenience method
`protected DSLContext`	`create(Context<?> ctx)` Internal convenience method
`protected static <R extends Record,T> TableField<R,T>`	`createField(java.lang.String name, DataType<T> type, Table<R> table)` Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T> TableField<R,T>`	`createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment)` Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T,U> TableField<R,U>`	`createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment, Binding<T,U> binding)` Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T,U> TableField<R,U>`	`createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment, Converter<T,U> converter)` Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T,X,U> TableField<R,U>`	`createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment, Converter<X,U> converter, Binding<T,X> binding)` Subclasses may call this method to create `TableField` objects that are linked to this table.
`Table<Record>`	`crossApply(java.lang.String sql)` `CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(java.lang.String sql, java.lang.Object... bindings)` `CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(java.lang.String sql, QueryPart... parts)` `CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(TableLike<?> table)` `CROSS APPLY` a table to this table.
`Table<Record>`	`crossJoin(java.lang.String sql)` `CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(java.lang.String sql, java.lang.Object... bindings)` `CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(java.lang.String sql, QueryPart... parts)` `CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(TableLike<?> table)` `CROSS JOIN` a table to this table.
`boolean`	`declaresCTE()` Subclasses may override this
`boolean`	`declaresFields()` Subclasses may override this
`boolean`	`declaresTables()` Subclasses may override this
`boolean`	`declaresWindows()` Subclasses may override this
`DivideByOnStep`	`divideBy(Table<?> divisor)` Create a new `TABLE` reference from this table, applying relational division.
`<T> Field<T>`	`field(Field<T> field)` Get a specific field from this Record.
`Field<?>`	`field(int index)` Get a specific field from this Record.
`Field<?>`	`field(java.lang.String string)` Get a specific field from this Record.
`Field<?>[]`	`fields()` Get all fields from this Record.
`Row`	`fieldsRow()` Get this table's fields as a `Row`
`Table<R>`	`forceIndex(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forceIndexForGroupBy(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forceIndexForJoin(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forceIndexForOrderBy(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`TableOnStep`	`fullOuterJoin(java.lang.String sql)` `FULL OUTER JOIN` a table to this table.
`TableOnStep`	`fullOuterJoin(java.lang.String sql, java.lang.Object... bindings)` `FULL OUTER JOIN` a table to this table.
`TableOnStep`	`fullOuterJoin(java.lang.String sql, QueryPart... parts)` `FULL OUTER JOIN` a table to this table.
`TableOnStep`	`fullOuterJoin(TableLike<?> table)` `FULL OUTER JOIN` a table to this table.
`java.lang.String`	`getComment()` The comment given to the table.
`Identity<R,? extends java.lang.Number>`	`getIdentity()` Retrieve the table's `IDENTITY` information, if available.
`java.util.List<UniqueKey<R>>`	`getKeys()` Retrieve all of the table's unique keys.
`java.lang.String`	`getName()` The name of this table.
`UniqueKey<R>`	`getPrimaryKey()` Retrieve the table's primary key
`TableField<R,? extends java.util.Date>`	`getRecordTimestamp()` 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.
`abstract java.lang.Class<? extends R>`	`getRecordType()` Subclasses must implement this method Subclasses must override this method if they use the generic type parameter for other types than `Record` The record type produced by this table.
`TableField<R,? extends java.lang.Number>`	`getRecordVersion()` 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.
`java.util.List<ForeignKey<R,?>>`	`getReferences()` Get the list of `FOREIGN KEY`'s of this table
`<O extends Record> java.util.List<ForeignKey<O,R>>`	`getReferencesFrom(Table<O> other)` Get a list of `FOREIGN KEY`'s of a specific table, referencing a this table.
`<O extends Record> java.util.List<ForeignKey<R,O>>`	`getReferencesTo(Table<O> other)` Get a list of `FOREIGN KEY`'s of this table, referencing a specific table.
`Schema`	`getSchema()` Get the table schema.
`int`	`hashCode()` Generate a hash code from this `QueryPart`.
`Table<R>`	`ignoreIndex(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`ignoreIndexForGroupBy(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`ignoreIndexForJoin(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`ignoreIndexForOrderBy(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`TableOnStep`	`join(java.lang.String sql)` `INNER JOIN` a table to this table.
`TableOnStep`	`join(java.lang.String sql, java.lang.Object... bindings)` `INNER JOIN` a table to this table.
`TableOnStep`	`join(java.lang.String sql, QueryPart... parts)` `INNER JOIN` a table to this table.
`TableOnStep`	`join(TableLike<?> table)` `INNER JOIN` a table to this table.
`TableOptionalOnStep`	`join(TableLike<?> table, JoinType type)` 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.
`TablePartitionByStep`	`leftOuterJoin(java.lang.String sql)` `LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep`	`leftOuterJoin(java.lang.String sql, java.lang.Object... bindings)` `LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep`	`leftOuterJoin(java.lang.String sql, QueryPart... parts)` `LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep`	`leftOuterJoin(TableLike<?> table)` `LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalJoin(java.lang.String sql)` `NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(java.lang.String sql, java.lang.Object... bindings)` `NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(java.lang.String sql, QueryPart... parts)` `NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(TableLike<?> table)` `NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(java.lang.String sql)` `NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(java.lang.String sql, java.lang.Object... bindings)` `NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(java.lang.String sql, QueryPart... parts)` `NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(TableLike<?> table)` `NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(java.lang.String sql)` `NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(java.lang.String sql, java.lang.Object... bindings)` `NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(java.lang.String sql, QueryPart... parts)` `NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(TableLike<?> table)` `NATURAL RIGHT OUTER JOIN` a table to this table.
`R`	`newRecord()` Create a new `Record` of this table's type.
`Table<Record>`	`outerApply(java.lang.String sql)` `OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(java.lang.String sql, java.lang.Object... bindings)` `OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(java.lang.String sql, QueryPart... parts)` `OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(TableLike<?> table)` `OUTER APPLY` a table to this table.
`PivotForStep`	`pivot(java.util.Collection<? extends Field<?>> aggregateFunctions)` Create a new `TABLE` reference from this table, pivoting it into another form.
`PivotForStep`	`pivot(Field<?>... aggregateFunctions)` Create a new `TABLE` reference from this table, pivoting it into another form.
`RecordType<R>`	`recordType()` The record type produced by this table.
`TablePartitionByStep`	`rightOuterJoin(java.lang.String sql)` `RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep`	`rightOuterJoin(java.lang.String sql, java.lang.Object... bindings)` `RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep`	`rightOuterJoin(java.lang.String sql, QueryPart... parts)` `RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep`	`rightOuterJoin(TableLike<?> table)` `RIGHT OUTER JOIN` a table to this table.
`void`	`toSQL(RenderContext ctx)` Deprecated.
`java.lang.String`	`toString()` Render a SQL string of this `QueryPart` For improved debugging, this renders a SQL string of this `QueryPart` with inlined bind variables.
`protected DataAccessException`	`translate(java.lang.String sql, java.sql.SQLException e)` Internal convenience method
`Table<R>`	`useIndex(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`useIndexForGroupBy(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`useIndexForJoin(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`Table<R>`	`useIndexForOrderBy(java.lang.String... indexes)` Specify a MySQL style table hint for query optimisation.
`VersionsBetweenAndStep<R,java.lang.Number>`	`versionsBetweenScn(Field<? extends java.lang.Number> scn)` Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,java.lang.Number>`	`versionsBetweenScn(java.lang.Number scn)` Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,java.lang.Number>`	`versionsBetweenScnMinvalue()` Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,java.sql.Timestamp>`	`versionsBetweenTimestamp(Field<java.sql.Timestamp> timestamp)` Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,java.sql.Timestamp>`	`versionsBetweenTimestamp(java.sql.Timestamp timestamp)` Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,java.sql.Timestamp>`	`versionsBetweenTimestampMinvalue()` Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`Table<R>`	`with(java.lang.String hint)` Specify a SQL Server style table hint for query optimisation.

Methods inherited from class org.jooq.impl.TableImpl
accept, as, as, clauses, equals

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.QueryPart
toString

- Constructor Detail
  - CustomTable
```
protected CustomTable(java.lang.String name)
```
  - CustomTable
```
protected CustomTable(java.lang.String name,
                      Schema schema)
```
- Method Detail
  - getRecordType
```
public abstract java.lang.Class<? extends R> getRecordType()
```
    Subclasses must implement this method
    Subclasses must override this method if they use the generic type parameter for other types than Record
    The record type produced by this table.
    
    Specified by:
    
    getRecordType in interface Table<R extends TableRecord<R>>
    
    Overrides:
    
    getRecordType in class TableImpl<R extends TableRecord<R>>
  - getIdentity
```
public Identity<R,? extends java.lang.Number> getIdentity()
```
    Retrieve the table's IDENTITY information, if available.
    With SQL:2003, the concept of IDENTITY columns was introduced in most RDBMS. These are special kinds of columns that have auto-increment functionality when INSERT statements are performed.
    An IDENTITY column is usually part of the PRIMARY KEY or of a UNIQUE KEY in the table, although in some RDBMS, this is not required. There can only be at most one IDENTITY column.
    Note: Unfortunately, this is not supported in the Oracle dialect, where identities simulated by triggers cannot be formally detected.
    Subclasses should override this method
    
    Specified by:
    
    getIdentity in interface Table<R extends TableRecord<R>>
    
    Returns:
    
    The table's IDENTITY information, or null, if no such information is available.
  - getPrimaryKey
```
public UniqueKey<R> getPrimaryKey()
```
    Retrieve the table's primary key
    Subclasses may override this method
    
    Specified by:
    
    getPrimaryKey in interface Table<R extends TableRecord<R>>
    
    Returns:
    
    The primary key. This is never null for an updatable table.
  - getKeys
```
public java.util.List<UniqueKey<R>> getKeys()
```
    Retrieve all of the table's unique keys.
    Subclasses should override this method
    
    Specified by:
    
    getKeys in interface Table<R extends TableRecord<R>>
    
    Returns:
    
    All keys. This is never null. This is never empty for a Table with a Table.getPrimaryKey(). This method returns an unmodifiable list.
  - getReferences
```
public java.util.List<ForeignKey<R,?>> getReferences()
```
    Get the list of FOREIGN KEY's of this table
    Subclasses should override this method
    
    Specified by:
    
    getReferences in interface Table<R extends TableRecord<R>>
    
    Returns:
    
    This table's FOREIGN KEY's. This is never null.
  - declaresFields
```
public final boolean declaresFields()
```
    Subclasses may override this
    
    Specified by:
    
    declaresFields in interface QueryPartInternal
  - declaresTables
```
public final boolean declaresTables()
```
    Subclasses may override this
    
    Specified by:
    
    declaresTables in interface QueryPartInternal
    
    Overrides:
    
    declaresTables in class TableImpl<R extends TableRecord<R>>
  - recordType
```
public final RecordType<R> recordType()
```
    Description copied from interface: Table
    
    The record type produced by this table.
    
    Specified by:
    
    recordType in interface Table<R extends Record>
  - newRecord
```
public final R newRecord()
```
    Description copied from interface: Table
    
    Create a new Record of this table's type.
    
    Specified by:
    
    newRecord in interface Table<R extends Record>
    
    See Also:
    
    DSLContext.newRecord(Table)
  - fieldsRow
```
public final Row fieldsRow()
```
    Description copied from interface: TableLike
    
    Get this table's fields as a Row
    
    Specified by:
    
    fieldsRow in interface TableLike<R extends Record>
  - field
```
public final <T> Field<T> field(Field<T> field)
```
    Description copied from interface: TableLike
    
    Get a specific field from this Record.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(Field)
  - field
```
public final Field<?> field(java.lang.String string)
```
    Description copied from interface: TableLike
    
    Get a specific field from this Record.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(String)
  - field
```
public final Field<?> field(int index)
```
    Description copied from interface: TableLike
    
    Get a specific field from this Record.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(int)
  - fields
```
public final Field<?>[] fields()
```
    Description copied from interface: TableLike
    
    Get all fields from this Record.
    
    Specified by:
    
    fields in interface TableLike<R extends Record>
    
    See Also:
    
    Row.fields()
  - asTable
```
public final Table<R> asTable()
```
    Description copied from interface: TableLike
    
    The underlying table representation of this object
    This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
  - asTable
```
public final Table<R> asTable(java.lang.String alias)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String)
  - asTable
```
public final Table<R> asTable(java.lang.String alias,
                              java.lang.String... fieldAliases)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String, String...)
  - getSchema
```
public final Schema getSchema()
```
    Description copied from interface: Table
    
    Get the table schema.
    
    Specified by:
    
    getSchema in interface Table<R extends Record>
  - getName
```
public final java.lang.String getName()
```
    Description copied from interface: Table
    
    The name of this table.
    
    Specified by:
    
    getName in interface Table<R extends Record>
  - getComment
```
public final java.lang.String getComment()
```
    Description copied from interface: Table
    
    The comment given to the table.
    If this Table is a generated table from your database, it may provide its DDL comment through this method. All other table expressions return the empty string "" here, never null.
    
    Specified by:
    
    getComment in interface Table<R extends Record>
  - getRecordVersion
```
public TableField<R,? extends java.lang.Number> getRecordVersion()
```
    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. Optimistic locking is performed in a single UPDATE or DELETE statement if tables provide a "version" or "timestamp" field, or in two steps using an additional SELECT .. FOR UPDATE statement otherwise.
    This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.
    Subclasses may override this method
    
    Specified by:
    
    getRecordVersion in interface Table<R extends Record>
    
    Returns:
    
    The "version" field, or null, if this table has no "version" field.
    
    See Also:
    
    Table.getRecordTimestamp(), UpdatableRecord.store(), UpdatableRecord.delete(), Settings.isExecuteWithOptimisticLocking()
  - getRecordTimestamp
```
public TableField<R,? extends java.util.Date> getRecordTimestamp()
```
    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. Optimistic locking is performed in a single UPDATE or DELETE statement if tables provide a "version" or "timestamp" field, or in two steps using an additional SELECT .. FOR UPDATE statement otherwise.
    This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.
    Subclasses may override this method
    
    Specified by:
    
    getRecordTimestamp in interface Table<R extends Record>
    
    Returns:
    
    The "timestamp" field, or null, if this table has no "timestamp" field.
    
    See Also:
    
    Table.getRecordVersion(), UpdatableRecord.store(), UpdatableRecord.delete(), Settings.isExecuteWithOptimisticLocking()
  - getReferencesFrom
```
public final <O extends Record> java.util.List<ForeignKey<O,R>> getReferencesFrom(Table<O> other)
```
    Get a list of FOREIGN KEY's of a specific table, referencing a this table.
    
    Specified by:
    
    getReferencesFrom in interface Table<R extends Record>
    
    Type Parameters:
    
    O - The other table's record type
    
    Parameters:
    
    other - The other table of the foreign key relationship
    
    Returns:
    
    Some other table's FOREIGN KEY's towards an this table. This is never null. This method returns an unmodifiable list.
  - getReferencesTo
```
public final <O extends Record> java.util.List<ForeignKey<R,O>> getReferencesTo(Table<O> other)
```
    Get a list of FOREIGN KEY's of this table, referencing a specific table.
    
    Specified by:
    
    getReferencesTo in interface Table<R extends Record>
    
    Type Parameters:
    
    O - The other table's record type
    
    Parameters:
    
    other - The other table of the foreign key relationship
    
    Returns:
    
    This table's FOREIGN KEY's towards an other table. This is never null.
  - createField
```
protected static final <R extends Record,T> TableField<R,T> createField(java.lang.String name,
                                                                        DataType<T> type,
                                                                        Table<R> table)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T> TableField<R,T> createField(java.lang.String name,
                                                                        DataType<T> type,
                                                                        Table<R> table,
                                                                        java.lang.String comment)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T,U> TableField<R,U> createField(java.lang.String name,
                                                                          DataType<T> type,
                                                                          Table<R> table,
                                                                          java.lang.String comment,
                                                                          Converter<T,U> converter)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T,U> TableField<R,U> createField(java.lang.String name,
                                                                          DataType<T> type,
                                                                          Table<R> table,
                                                                          java.lang.String comment,
                                                                          Binding<T,U> binding)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T,X,U> TableField<R,U> createField(java.lang.String name,
                                                                            DataType<T> type,
                                                                            Table<R> table,
                                                                            java.lang.String comment,
                                                                            Converter<X,U> converter,
                                                                            Binding<T,X> binding)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - useIndex
```
public final Table<R> useIndex(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndex("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    useIndex in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - useIndexForJoin
```
public final Table<R> useIndexForJoin(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForJoin("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    useIndexForJoin in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - useIndexForOrderBy
```
public final Table<R> useIndexForOrderBy(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    useIndexForOrderBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - useIndexForGroupBy
```
public final Table<R> useIndexForGroupBy(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    useIndexForGroupBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndex
```
public final Table<R> ignoreIndex(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndex("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    ignoreIndex in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndexForJoin
```
public final Table<R> ignoreIndexForJoin(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForJoin("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    ignoreIndexForJoin in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndexForOrderBy
```
public final Table<R> ignoreIndexForOrderBy(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    ignoreIndexForOrderBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndexForGroupBy
```
public final Table<R> ignoreIndexForGroupBy(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    ignoreIndexForGroupBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndex
```
public final Table<R> forceIndex(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndex("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    forceIndex in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndexForJoin
```
public final Table<R> forceIndexForJoin(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForJoin("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    forceIndexForJoin in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndexForOrderBy
```
public final Table<R> forceIndexForOrderBy(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    forceIndexForOrderBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndexForGroupBy
```
public final Table<R> forceIndexForGroupBy(java.lang.String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
```
 create.select()
       .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
       .fetch();
 
```
    Specified by:
    
    forceIndexForGroupBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - with
```
public final Table<R> with(java.lang.String hint)
```
    Description copied from interface: Table
    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.
    Example:
```
 create.select()
       .from(BOOK.as("b").with("READUNCOMMITTED")
       .fetch();
 
```
    For SQLDialect.ORACLE style hints, see SelectFromStep.hint(String) and SelectQuery.addHint(String)
    Specified by:
    
    with in interface Table<R extends Record>
    
    See Also:
    
    http://msdn.microsoft.com/en-us/library/ms187373.aspx, SelectFromStep.hint(String), SelectQuery.addHint(String)
  - pivot
```
public final PivotForStep pivot(Field<?>... aggregateFunctions)
```
    Description copied from interface: Table
    Create a new TABLE reference from this table, pivoting it into another form.
    This has been observed to work with
    - SQLDialect.ORACLE11G upwards
    - SQLDialect.SQLSERVER (not yet officially supported)
    - Other dialects by using some means of simulation (not yet officially supported)
    Specified by:
    
    pivot in interface Table<R extends Record>
    
    Parameters:
    
    aggregateFunctions - The aggregate functions used for pivoting.
    
    Returns:
    
    A DSL object to create the PIVOT expression
  - pivot
```
public final PivotForStep pivot(java.util.Collection<? extends Field<?>> aggregateFunctions)
```
    Description copied from interface: Table
    
    Create a new TABLE reference from this table, pivoting it into another form.
    For more details, see Table.pivot(Field...)
    
    Specified by:
    
    pivot in interface Table<R extends Record>
    
    Parameters:
    
    aggregateFunctions - The aggregate functions used for pivoting.
    
    Returns:
    
    A DSL object to create the PIVOT expression
    
    See Also:
    
    Table.pivot(Field...)
  - versionsBetweenScn
```
public final VersionsBetweenAndStep<R,java.lang.Number> versionsBetweenScn(java.lang.Number scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenScn in interface Table<R extends Record>
  - versionsBetweenScn
```
public final VersionsBetweenAndStep<R,java.lang.Number> versionsBetweenScn(Field<? extends java.lang.Number> scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenScn in interface Table<R extends Record>
  - versionsBetweenScnMinvalue
```
public final VersionsBetweenAndStep<R,java.lang.Number> versionsBetweenScnMinvalue()
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenScnMinvalue in interface Table<R extends Record>
  - versionsBetweenTimestamp
```
public final VersionsBetweenAndStep<R,java.sql.Timestamp> versionsBetweenTimestamp(java.sql.Timestamp timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenTimestamp in interface Table<R extends Record>
  - versionsBetweenTimestamp
```
public final VersionsBetweenAndStep<R,java.sql.Timestamp> versionsBetweenTimestamp(Field<java.sql.Timestamp> timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenTimestamp in interface Table<R extends Record>
  - versionsBetweenTimestampMinvalue
```
public final VersionsBetweenAndStep<R,java.sql.Timestamp> versionsBetweenTimestampMinvalue()
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenTimestampMinvalue in interface Table<R extends Record>
  - asOfScn
```
public final Table<R> asOfScn(java.lang.Number scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfScn in interface Table<R extends Record>
  - asOfScn
```
public final Table<R> asOfScn(Field<? extends java.lang.Number> scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfScn in interface Table<R extends Record>
  - asOfTimestamp
```
public final Table<R> asOfTimestamp(java.sql.Timestamp timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfTimestamp in interface Table<R extends Record>
  - asOfTimestamp
```
public final Table<R> asOfTimestamp(Field<java.sql.Timestamp> timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfTimestamp in interface Table<R extends Record>
  - divideBy
```
public final DivideByOnStep divideBy(Table<?> divisor)
```
    Description copied from interface: Table
    Create a new TABLE reference from this table, applying relational division.
    Relational division is the inverse of a cross join operation. The following is an approximate definition of a relational division:
```
 Assume the following cross join / cartesian product
 C = A × B

 Then it can be said that
 A = C ÷ B
 B = C ÷ A
 
```
    With jOOQ, you can simplify using relational divisions by using the following syntax:
```
 C.divideBy(B).on(C.ID.equal(B.C_ID)).returning(C.TEXT)
 
```
    The above roughly translates to
```
 SELECT DISTINCT C.TEXT FROM C "c1"
 WHERE NOT EXISTS (
   SELECT 1 FROM B
   WHERE NOT EXISTS (
     SELECT 1 FROM C "c2"
     WHERE "c2".TEXT = "c1".TEXT
     AND "c2".ID = B.C_ID
   )
 )
 
```
    Or in plain text: Find those TEXT values in C whose ID's correspond to all ID's in B. Note that from the above SQL statement, it is immediately clear that proper indexing is of the essence. Be sure to have indexes on all columns referenced from the on(...) and returning(...) clauses.
    For more information about relational division and some nice, real-life examples, see
    - http ://en.wikipedia.org/wiki/Relational_algebra#Division
    - http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the- sql-of-relational-division/
    This has been observed to work with all dialects
    Specified by:
    
    divideBy in interface Table<R extends Record>
  - join
```
public final TableOptionalOnStep join(TableLike<?> table,
                                      JoinType type)
```
    Description copied from interface: Table
    
    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. If it is required but omitted, a DSL.trueCondition(), i.e. 1 = 1 condition will be rendered
    
    Specified by:
    
    join in interface Table<R extends Record>
  - join
```
public final TableOnStep join(TableLike<?> table)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    
    Specified by:
    
    join in interface Table<R extends Record>
  - join
```
public final TableOnStep join(java.lang.String sql)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - join
```
public final TableOnStep join(java.lang.String sql,
                              java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - join
```
public final TableOnStep join(java.lang.String sql,
                              QueryPart... parts)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - leftOuterJoin
```
public final TablePartitionByStep leftOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
  - leftOuterJoin
```
public final TablePartitionByStep leftOuterJoin(java.lang.String sql)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - leftOuterJoin
```
public final TablePartitionByStep leftOuterJoin(java.lang.String sql,
                                                java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - leftOuterJoin
```
public final TablePartitionByStep leftOuterJoin(java.lang.String sql,
                                                QueryPart... parts)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - rightOuterJoin
```
public final TablePartitionByStep rightOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
  - rightOuterJoin
```
public final TablePartitionByStep rightOuterJoin(java.lang.String sql)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - rightOuterJoin
```
public final TablePartitionByStep rightOuterJoin(java.lang.String sql,
                                                 java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - rightOuterJoin
```
public final TablePartitionByStep rightOuterJoin(java.lang.String sql,
                                                 QueryPart... parts)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - fullOuterJoin
```
public final TableOnStep fullOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
  - fullOuterJoin
```
public final TableOnStep fullOuterJoin(java.lang.String sql)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - fullOuterJoin
```
public final TableOnStep fullOuterJoin(java.lang.String sql,
                                       java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - fullOuterJoin
```
public final TableOnStep fullOuterJoin(java.lang.String sql,
                                       QueryPart... parts)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - crossJoin
```
public final Table<Record> crossJoin(TableLike<?> table)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:
```
 A cross join B
 A join B on 1 = 1
 
```
    Specified by:
    
    crossJoin in interface Table<R extends Record>
  - crossJoin
```
public final Table<Record> crossJoin(java.lang.String sql)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:
```
 A cross join B
 A join B on 1 = 1
 
```
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - crossJoin
```
public final Table<Record> crossJoin(java.lang.String sql,
                                     java.lang.Object... bindings)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:
```
 A cross join B
 A join B on 1 = 1
 
```
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - crossJoin
```
public final Table<Record> crossJoin(java.lang.String sql,
                                     QueryPart... parts)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:
```
 A cross join B
 A join B on 1 = 1
 
```
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - naturalJoin
```
public final Table<Record> naturalJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
  - naturalJoin
```
public final Table<Record> naturalJoin(java.lang.String sql)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - naturalJoin
```
public final Table<Record> naturalJoin(java.lang.String sql,
                                       java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - naturalJoin
```
public final Table<Record> naturalJoin(java.lang.String sql,
                                       QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(java.lang.String sql)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(java.lang.String sql,
                                                java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(java.lang.String sql,
                                                QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(java.lang.String sql)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(java.lang.String sql,
                                                 java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(java.lang.String sql,
                                                 QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - crossApply
```
public final Table<Record> crossApply(TableLike<?> table)
```
    Description copied from interface: Table
    
    CROSS APPLY a table to this table.
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
  - crossApply
```
public final Table<Record> crossApply(java.lang.String sql)
```
    Description copied from interface: Table
    
    CROSS APPLY a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - crossApply
```
public final Table<Record> crossApply(java.lang.String sql,
                                      java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    CROSS APPLY a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - crossApply
```
public final Table<Record> crossApply(java.lang.String sql,
                                      QueryPart... parts)
```
    Description copied from interface: Table
    
    CROSS APPLY a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - outerApply
```
public final Table<Record> outerApply(TableLike<?> table)
```
    Description copied from interface: Table
    
    OUTER APPLY a table to this table.
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
  - outerApply
```
public final Table<Record> outerApply(java.lang.String sql)
```
    Description copied from interface: Table
    
    OUTER APPLY a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String)
  - outerApply
```
public final Table<Record> outerApply(java.lang.String sql,
                                      java.lang.Object... bindings)
```
    Description copied from interface: Table
    
    OUTER APPLY a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...)
  - outerApply
```
public final Table<Record> outerApply(java.lang.String sql,
                                      QueryPart... parts)
```
    Description copied from interface: Table
    
    OUTER APPLY a table to this table.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...)
  - hashCode
```
public int hashCode()
```
    Description copied from interface: QueryPart
    
    Generate a hash code from this QueryPart.
    In general, QueryPart hash codes are the same as the hash codes generated from QueryPart.toString(). This guarantees consistent behaviour with QueryPart.equals(Object)
    Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.
    
    Specified by:
    
    hashCode in interface QueryPart
    
    Returns:
    
    The QueryPart hash code
  - toSQL
```
@Deprecated
public void toSQL(RenderContext ctx)
```
    Deprecated.
    
    Description copied from interface: QueryPartInternal
    
    Render this QueryPart to a SQL string contained in context.sql(). The context will contain additional information about how to render this QueryPart, e.g. whether this QueryPart should be rendered as a declaration or reference, whether this QueryPart's contained bind variables should be inlined or replaced by '?', etc.
    
    Specified by:
    
    toSQL in interface QueryPartInternal
  - bind
```
@Deprecated
public void bind(BindContext ctx)
                       throws DataAccessException
```
    Deprecated.
    
    Description copied from interface: QueryPartInternal
    
    Bind all parameters of this QueryPart to a PreparedStatement
    This method is for JOOQ INTERNAL USE only. Do not reference directly
    
    Specified by:
    
    bind in interface QueryPartInternal
    
    Parameters:
    
    ctx - The context holding the next bind index and other information for variable binding
    
    Throws:
    
    DataAccessException - If something went wrong while binding a variable
  - declaresWindows
```
public boolean declaresWindows()
```
    Subclasses may override this
    
    Specified by:
    
    declaresWindows in interface QueryPartInternal
  - declaresCTE
```
public boolean declaresCTE()
```
    Subclasses may override this
    
    Specified by:
    
    declaresCTE in interface QueryPartInternal
  - toString
```
public java.lang.String toString()
```
    Description copied from interface: QueryPart
    
    Render a SQL string of this QueryPart
    For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables. If you wish to gain more control over the concrete SQL rendering of this QueryPart, use DSLContext.renderContext() to obtain a configurable render context for SQL rendering.
    
    Specified by:
    
    toString in interface QueryPart
    
    Overrides:
    
    toString in class java.lang.Object
    
    Returns:
    
    A SQL string representation of this QueryPart
  - create
```
protected final DSLContext create()
```
    Internal convenience method
  - create
```
protected final DSLContext create(Configuration configuration)
```
    Internal convenience method
  - create
```
protected final DSLContext create(Context<?> ctx)
```
    Internal convenience method
  - translate
```
protected final DataAccessException translate(java.lang.String sql,
                                              java.sql.SQLException e)
```
    Internal convenience method

Class CustomTable<R extends TableRecord<R>>

Field Summary

Fields inherited from class org.jooq.impl.TableImpl

Constructor Summary

Method Summary

Methods inherited from class org.jooq.impl.TableImpl

Methods inherited from class java.lang.Object

Methods inherited from interface org.jooq.QueryPart

Constructor Detail

CustomTable

CustomTable

Method Detail

getRecordType

getIdentity

getPrimaryKey

getKeys

getReferences

declaresFields

declaresTables

recordType

newRecord

fieldsRow

field

field

field

fields

asTable

asTable

asTable

getSchema

getName

getComment

getRecordVersion

getRecordTimestamp

getReferencesFrom

getReferencesTo

createField

createField

createField

createField

createField

useIndex

useIndexForJoin

useIndexForOrderBy

useIndexForGroupBy

ignoreIndex

ignoreIndexForJoin

ignoreIndexForOrderBy

ignoreIndexForGroupBy

forceIndex

forceIndexForJoin

forceIndexForOrderBy

forceIndexForGroupBy

with

pivot

pivot

versionsBetweenScn

versionsBetweenScn

versionsBetweenScnMinvalue

versionsBetweenTimestamp

versionsBetweenTimestamp

versionsBetweenTimestampMinvalue

asOfScn

asOfScn

asOfTimestamp

asOfTimestamp

divideBy

join

join

join

join

join

leftOuterJoin

leftOuterJoin

leftOuterJoin

leftOuterJoin

rightOuterJoin

rightOuterJoin

rightOuterJoin

rightOuterJoin