Purpose
The information_schema.TABLES view provides information about tables.
Note
This view is introduced since OceanBase Database V1.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_CATALOG | varchar(512) | NO | The name of the catalog to which the table belongs. |
| TABLE_SCHEMA | varchar(64) | NO | The name of the database. |
| TABLE_NAME | varchar(64) | NO | The name of the table. |
| TABLE_TYPE | varchar(64) | NO | The type of the table. |
| ENGINE | varchar(64) | NO | The type of the storage engine that is used. |
| VERSION | bigint(0) unsigned | NO | The version. |
| ROW_FORMAT | varchar(10) | NO | The line format. |
| TABLE_ROWS | bigint(21) unsigned | NO | The number of rows in the table. |
| AVG_ROW_LENGTH | bigint(21) unsigned | NO | The average length of the rows. |
| DATA_LENGTH | bigint(21) unsigned | NO | The data length. |
| MAX_DATA_LENGTH | bigint(0) unsigned | NO | The maximum data length. |
| INDEX_LENGTH | bigint(0) unsigned | NO | The index length. |
| DATA_FREE | bigint(0) unsigned | NO | The size of the remaining space. |
| AUTO_INCREMENT | bigint(0) unsigned | NO | The current auto-increment value. |
| CREATE_TIME | datetime | NO | The time when the table was created. |
| UPDATE_TIME | datetime | NO | The time when the table was last updated. |
| CHECK_TIME | datetime | NO | The time when the table was last checked. |
| TABLE_COLLATION | varchar(32) | NO | The name of the collation for the table. |
| CHECKSUM | bigint(0) unsigned | NO | The checksum. |
| CREATE_OPTIONS | varchar(255) | NO | The creation options. |
| TABLE_COMMENT | text | NO | The comment on the table. |
