TABLES System Table Description

Description

Information about all the persistent tables in the database.

Fields

Field Type 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

integer

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.

Indexes

Primary Index: TABLES..PRIMARY_KEY on fields: TABLENAME, SCHEMA
Secondary Index: TABLES_ST on fields: SCHEMA, TABLENAME