The data in a SESAM/SQL database is organized in tables. A table is a two-dimensional arrangement of data comprising rows and columns.
The rows in a table correspond to records. There is no particular sequence to the order of rows in a table. The number of rows in a table is not defined.
Every row in a table has the same number of columns. The name and data type of each column and the sequence of the columns is defined in the table definition. All the values in a given column are of the same data type. Although, according to the relational model, a table is not allowed to include duplicate rows, SQL allows them in principle. The SQL language does, however, does have the means to suppress duplicate rows.
There are the following types of tables:
base tables
partitioned tables (base tables which are distributed on a number of user spaces
views
derived tables
abstract tables
“read-only” tables