tables
tables provides information about tables.
The following fields are provided in tables:
| Field | Description |
|---|---|
| TABLE_CATALOG | Name of the catalog that stores the table. |
| TABLE_SCHEMA | Name of the database that stores the table. |
| TABLE_NAME | Name of the table. |
| TABLE_TYPE | Type of the table. Valid values: BASE TABLE or VIEW. |
| ENGINE | Engine type of the table. Valid values: StarRocks, MySQL, MEMORY or an empty string. |
| VERSION | Applies to a feature not available in StarRocks. |
| ROW_FORMAT | Applies to a feature not available in StarRocks. |
| TABLE_ROWS | Row count of the table. |
| AVG_ROW_LENGTH | Average row length (size) of the table. It is equivalent to DATA_LENGTH/TABLE_ROWS. Unit: Byte. |
| DATA_LENGTH | Data length (size) of the table. Unit: Byte. |
| MAX_DATA_LENGTH | Applies to a feature not available in StarRocks. |
| INDEX_LENGTH | Applies to a feature not available in StarRocks. |
| DATA_FREE | Applies to a feature not available in StarRocks. |
| AUTO_INCREMENT | Applies to a feature not available in StarRocks. |
| CREATE_TIME | The time when the table was created. |
| UPDATE_TIME | The last time when the table was updated. |
| CHECK_TIME | The last time when a consistency check was performed on the table. |
| TABLE_COLLATION | The default collation of the table. |
| CHECKSUM | Applies to a feature not available in StarRocks. |
| CREATE_OPTIONS | Applies to a feature not available in StarRocks. |
| TABLE_COMMENT | Comment on the table. |