Name 

Type 

Description 

catalog_id 

BIGINT 

Database this table belongs to. References syscatalogs (id) 

id 

BIGINT 

Table id. Unique to the server cluster. Each time a table is altered, a new id is assigned. The original id when the table was created is found in creation_stamp_id. 

name 

VARCHAR 

Table name, unique to the catalog. 

path 

VARCHAR 

Physical path to table data 

count 

BIGINT 

Approximate number of rows. This is generated by GENERATE STATISTICS 

part_fld 

SMALLINT 

The column which this table is partitioned on. Abbreviation of "partition field". References syscolumns(id) 

data_provider_id 

INTEGER 

The source provider of the data. Eg. Memory, disk or registry. 

creation_stamp_id 

BIGINT 

The first id of the table, assigned when it was created 

stats_timestamp 

DATETIME 

The last time the statistics were generated 

stats_utimestamp 

BIGINT 

The number of table modifications that had happened at the last GENERATE STATISTICS