You are here: Reference Information > SQL Reference Information > SQL System Tables > TABLES System Table Description

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  
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.

Indexes

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