Tables, rows, and columns

 

A table is a two-dimensional arrangement of data that consists of rows and columns.

The row is the horizontal part containing one or more columns. The column is the vertical part containing one or more rows of data of one data type. All data for a column must be of the same type. A table in SQL is a keyed or non-keyed physical file.

A materialized query table is a table that is used to contain materialized data that is derived from one or more source tables specified by a select-statement.

A partitioned table is a table whose data is contained in one or more local partitions (members).

 

Parent topic:

SQL objects

 

Related concepts

DB2 Multisystem

 

Related reference

Data types
Creating and altering a materialized query table