Understanding DB2®: Learning Visually with Examples

T

table

A named data object consisting of a specific number of columns and some unordered rows.

table check constraint

See [check constraint]

table collocation

In a partitioned database environment, a state that occurs when two tables are stored in the same database partition group and have the same number of compatible partitioning keys. When this happens, DB2 UDB can choose to perform the join or subquery processing at the database partition where the data is stored.

table expression

An expression that creates a temporary result table from a simple query. For example, a table expression might be a query that selects all the managers from several departments and further specifies that they have over 15 years of working experience and are located ...