# TABLES

This view contains information about the tables visible to the current node.

| Column Name       | Description                                                                                                       |
| ----------------- | ----------------------------------------------------------------------------------------------------------------- |
| `TABLE_CATALOG`   | Always =`def`.                                                                                                    |
| `TABLE_SCHEMA`    | The database the table belongs to (could be partitioned database, i.e.,`db_0`).                                   |
| `TABLE_NAME`      | Name of the table.                                                                                                |
| `TABLE_TYPE`      | The type of the table (i.e.,`SYSTEM VIEW`,`VIEW`,`TEMPORARY TABLE`,`GLOBAL TEMPORARY TABLE`, or`BASE TABLE`).     |
| `ENGINE`          | Always =`MemSQL`.                                                                                                 |
| `VERSION`         | NULL (currently unsupported).                                                                                     |
| `ROW_FORMAT`      | `COMPRESSION = SPARSE`if sparse compression is used.                                                              |
| `TABLE_ROWS`      | Row count for the table.                                                                                          |
| `AVG_ROW_LENGTH`  | NULL (currently unsupported).                                                                                     |
| `DATE_LENGTH`     | NULL (currently unsupported).                                                                                     |
| `MAX_DATA_LENGTH` | NULL (currently unsupported).                                                                                     |
| `INDEX_LENGTH`    | NULL (currently unsupported).                                                                                     |
| `DATA_FREE`       | NULL (currently unsupported).                                                                                     |
| `AUTO_INCREMENT`  | The auto increment counter of the auto increment column (or NULL if not in use).                                  |
| `CREATE_TIME`     | Time the table was created (SQL timestamp).                                                                       |
| `UPDATE_TIME`     | NULL (currently unsupported).                                                                                     |
| `CHECK_TIME`      | NULL (currently unsupported).                                                                                     |
| `TABLE_COLLATION` | NULL (currently unsupported).                                                                                     |
| `CHECKSUM`        | NULL (currently unsupported).                                                                                     |
| `CREATE_OPTIONS`  | NULL (currently unsupported).                                                                                     |
| `TABLE_COMMENT`   | Comment from the`CREATE TABLE`statement, if specified.                                                            |
| `DISTRIBUTED`     | `1`if table is sharded,`0`otherwise.                                                                              |
| `STORAGE_TYPE`    | `COLUMNSTORE`for columnstore databases.`INMEMORY_ROWSTORE`for rowstore.                                           |
| `ALTER_TIME`      | Time of the most recent change to the table (SQL timestamp) or the`CREATE_TIME`if the table has not been altered. |
| `ALTER_USER`      | Name of the user that made the most recent change to the table.                                                   |
| `CREATE_USER`     | Name of the user that created the table.                                                                          |

***

Modified at: October 5, 2022

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/tables/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/tables/)

(An index of the documentation is available at /llms.txt)