tables

tables provides information about tables.

The following fields are provided in tables:

FieldDescription
TABLE_CATALOGName of the catalog that stores the table.
TABLE_SCHEMAName of the database that stores the table.
TABLE_NAMEName of the table.
TABLE_TYPEType of the table. Valid values: BASE TABLE or VIEW.
ENGINEEngine type of the table. Valid values: StarRocks, MySQL, MEMORY or an empty string.
VERSIONApplies to a feature not available in CelerData.
ROW_FORMATApplies to a feature not available in CelerData.
TABLE_ROWSRow count of the table.
AVG_ROW_LENGTHAverage row length (size) of the table. It is equivalent to DATA_LENGTH/TABLE_ROWS. Unit: Byte.
DATA_LENGTHData length (size) of the table. Unit: Byte.
MAX_DATA_LENGTHApplies to a feature not available in CelerData.
INDEX_LENGTHApplies to a feature not available in CelerData.
DATA_FREEApplies to a feature not available in CelerData.
AUTO_INCREMENTApplies to a feature not available in CelerData.
CREATE_TIMEThe time when the table was created.
UPDATE_TIMEThe last time when the table was updated.
CHECK_TIMEThe last time when a consistency check was performed on the table.
TABLE_COLLATIONThe default collation of the table.
CHECKSUMApplies to a feature not available in CelerData.
CREATE_OPTIONSApplies to a feature not available in CelerData.
TABLE_COMMENTComment on the table.
In this article