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

Deprecated

TYPE

varchar(16)

TABLE, SYSTEM TABLE or VIEW

SUBTYPE

integer

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

Deprecated

VIEWDEFINITION

clob

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

CARDINALITY

bigint

Deprecated

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.

AUTOCREATESTATS

boolean

Reserved for future use.

NORECOMPUTE

boolean

Reserved for future use.

Indexes

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