TABLES System Table Description

TABLENAME

string

Name of the table

SCHEMA

string

Name of the schema containing the table

EXTENDS

string

Name of "base" class if EXTENDS is used as in CREATE TABLE t2 (…​) EXTENDS t1; In this case, the EXTENDS column would have the string T1

TYPE

varchar(16)

TABLE, SYSTEM TABLE or VIEW

SUBTYPE

integer

Usually 0 but incremented by 1 for every EXTENDS level in the creation of the table. In the example above for EXTENDS, the table t2 would have an entry in SYSTEM.TABLES with SUBTYPE=1 instead of 0.

TABLEID

bigint

Unique identifier for the table.

CURRENTVERSION

integer

The identifier of the TableFormat to be used for new records that are going to be added.

REMARKS

text

Unused

VIEWDEFINITION

clob

For views, this would be the SQL to create the view; Otherwise, null

CARDINALITY

bigint

Unused

RECORDSBATCHFACTOR

integer

The number of records we attempt to put into each RECORDDATA atom.

OBJECTID

bigint

The identifier for the database object.

INDEXFORMATVERSION

integer

The identifier for an index format version for the table.