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 |
Deprecated |
TYPE |
varchar(16) |
|
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 |
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. |