Uses of Interface
com.healthmarketscience.sqlbuilder.dbspec.Table

Packages that use Table

Package	Description
com.healthmarketscience.sqlbuilder	Builder-style classes for generating a wide variety of SQL statements (see the Syntax Reference for the major highlights).
com.healthmarketscience.sqlbuilder.dbspec	Group of interfaces which simplify the usage of SqlBuilder when multiple queries will be built over the same collection of database objects.
com.healthmarketscience.sqlbuilder.dbspec.basic	Very basic implementations of the dbspec interfaces.

Uses of Table in com.healthmarketscience.sqlbuilder

Methods in com.healthmarketscience.sqlbuilder that return Table

Modifier and Type	Method and Description
Table	CommonTableExpression.getTable() Returns the pseudo Table instance for this CTE.

Methods in com.healthmarketscience.sqlbuilder that return types with arguments of type Table

Modifier and Type	Method and Description
protected Collection<Table>	ValidationContext.getColumnTables() Retrieves the tables referenced by the column objects.
protected Collection<Table>	ValidationContext.getColumnTables(Collection<Table> columnTables) Retrieves the tables referenced by the column objects.
Collection<Table>	ValidationContext.getTables()

Methods in com.healthmarketscience.sqlbuilder with parameters of type Table

Modifier and Type	Method and Description
SelectQuery	SelectQuery.addAllTableColumns(Table table) Adds a "<alias>.*" column to the select column list.
SelectQuery	SelectQuery.addFromTable(Table table) Adds a table to the FROM clause, should not be used with any add*Join methods
SelectQuery	SelectQuery.addJoin(SelectQuery.JoinType joinType, Table fromTable, Table toTable, Column fromColumn, Column toColumn) Adds a join of the given type from fromTable to toTable with a join condition requiring fromColumn to equal toColumn.
SelectQuery	SelectQuery.addJoin(SelectQuery.JoinType joinType, Table fromTable, Table toTable, Condition joinCond) Adds a join of the given type from fromTable to toTable on joinCond of the given join type.
SelectQuery	SelectQuery.addJoin(SelectQuery.JoinType joinType, Table fromTable, Table toTable, List<? extends Column> fromColumns, List<? extends Column> toColumns) Adds a join of the given type from fromTable to toTable with a join condition requiring each column in fromColumns to equal the corresponding column in toColumns.
void	ValidationContext.addTable(Table table)
static DropQuery	DropQuery.dropTable(Table table)
static DropQuery	DropQuery.dropView(Table table)
static BaseGrantQuery.TargetObject	BaseGrantQuery.targetTable(Table table)
static SqlObject	Converter.toTableDefSqlObject(Table table) Converts a Table to a table definition SqlObject.
static SqlObject	Converter.toTableSqlObject(Table table) Converts a Table to a SqlObject.

Method parameters in com.healthmarketscience.sqlbuilder with type arguments of type Table

Modifier and Type	Method and Description
protected Collection<Table>	ValidationContext.getColumnTables(Collection<Table> columnTables) Retrieves the tables referenced by the column objects.
void	ValidationContext.setTables(Collection<Table> newTables)

Constructors in com.healthmarketscience.sqlbuilder with parameters of type Table

Constructor and Description
AddForeignConstraintAction(Table table) Deprecated. Creates a new AlterTableQuery.AddForeignConstraintAction which references the given Table.
AlterTableQuery(Table table)
CreateIndexQuery(Table table, Object index)
CreateIndexQuery(Table table, String indexName)
CreateTableQuery(Table table)
CreateTableQuery(Table table, boolean includeColumns) Column -> SqlObject conversions handled by Converter.TYPED_COLUMN_TO_OBJ.
CreateViewQuery(Table table)
DeleteQuery(Table table)
InsertQuery(Table table)
InsertSelectQuery(Table table)
UpdateQuery(Table table)

Constructor parameters in com.healthmarketscience.sqlbuilder with type arguments of type Table

Constructor and Description
ValidationContext(Collection<Table> tables, Collection<Column> columns)
ValidationContext(ValidationContext parent, Collection<Table> tables, Collection<Column> columns, boolean localOnly)

Uses of Table in com.healthmarketscience.sqlbuilder.dbspec

Classes in com.healthmarketscience.sqlbuilder.dbspec that implement Table

Modifier and Type	Class and Description
class	RejoinTable Utility class for using a table multiple times in the same query with different aliases.

Methods in com.healthmarketscience.sqlbuilder.dbspec that return Table

Modifier and Type	Method and Description
Table	Join.getFromTable()
Table	RejoinTable.getOriginalTable()
Table	ForeignKeyConstraint.getReferencedTable()
Table	Column.getTable()
Table	Index.getTable()
Table	Join.getToTable()

Constructors in com.healthmarketscience.sqlbuilder.dbspec with parameters of type Table

Constructor and Description
RejoinTable(Table table, String alias)

Uses of Table in com.healthmarketscience.sqlbuilder.dbspec.basic

Classes in com.healthmarketscience.sqlbuilder.dbspec.basic that implement Table

Modifier and Type	Class and Description
class	DbTable Representation of a table in a database schema.