SHOW TABLE STATUS

SHOW TABLE STATUS provides table metadata including storage engine, row count, and other status information.

Description

SHOW TABLE STATUS provides metadata about tables in a database, similar to MySQL. However, the result columns and values differ from MySQL because MatrixOne uses the Tae (Transactional Analytical Engine) storage engine instead of InnoDB. The Engine column always shows Tae.

Syntax

> SHOW TABLE STATUS
    [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

Examples

drop database if exists demo_1;
create database demo_1;
use demo_1;
create table t1 (col1 int);

mysql> show table status from demo_1;
+------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+---------+
| Name | Engine | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time    | Update_time         | Check_time  | Collation  | Checksum        | Create_options | Comment | Role_id | Role_name |
+------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+----------------+---------------------+-------------+------------+-----------------+----------------+---------+---------+-----------+
| t1   | Tae    | Dynamic    |    0 |              0 |           0 |               0 |            0 | NULL      |              0 | 2026-05-21     | NULL                | NULL         | utf8mb4_bin| NULL            |                |         |       0 | moadmin   |
+------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+----------------+---------------------+-------------+------------+-----------------+----------------+---------+---------+-----------+
1 row in set (0.00 sec)