TABLES System Table Description
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 |
TYPE |
varchar(16) |
|
SUBTYPE |
integer |
Usually 0 but incremented by 1 for every |
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 |
OBJECTID |
bigint |
The identifier for the database object. |