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 system-period temporal table is a table that has a related history table that is used by the system to save all historical versions of rows for the table.

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