# SHOW TABLE STATUS
`SHOW TABLE STATUS` is used to show information about tables in a given database or all databases, excluding hidden databases.
If no database is used, `SHOW TABLE STATUS` will display information about all tables in all databases, excluding hidden databases.
If a database is specified, the statement will only display information about the tables in the given database.
```sql
SHOW TABLE STATUS [LIKE Pattern];
```
`LIKE Pattern` is optional, which has the same semantics as the `LIKE` operation, and used to match the database name.
For example, `'%'` means all databases, including the hidden ones.
## Output Information
| Column | Note |
| ---------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Table_id | It shows the unique id of the table. |
| Table_name | It shows the name of the table. |
| Database_name | It shows the name of the database, which the table belongs to. |
| Storage_type | It shows the storage type of the table. There are three types of value: `memory`,`ssd` and `hdd`. |
| Rows | It shows the number of rows in this table. |
| Memory_data_size | It shows the memory usage of the table in bytes. |
| Disk_data_size | It shows the disk usage of the table in bytes. |
| Partition | It shows the number of partitons of the table. |
| Partition_unalive | It shows the number of the unalive partitions of the table. |
| Replica | It shows the number of replicas of the table. |
| Offline_path | It shows the path of the offline data for this table and is valid only for offline tables. The `NULL` value means the path is not set. |
| Offline_format | It shows the offline data format of the table and is valid only for offline tables. The `NULL` value means it is not set. |
| Offline_symbolic_paths | It shows the paths that load data in deep_copy==false way. The `NULL` value means it is not set. |
| Warnings | Warnings related to the table, including the following four types：
1) `leader/follower mode inconsistent`: the leader/follower information from nameserver is not consistent with those in tablet
2) `state is kNotFound/kTableUndefined/kTableLoading`：the partition is unavailable, `kNotFound` means the partition does not exist; `kTableUndefined` means the partition is not loaded successfully; `kTableLoading` means the partition is being loaded
3) `real replica number xx does not match the configured replicanum xx`：the number of replicas != `replicanum`
4) `not connected to leader`：follower is not connected to the leader, which usually occurs together with 3) |
```{note}
When version <=0.8.1, `Offline_symbolic_paths` doesn't exist, the position is used by `Offline_deep_copy` instead.
```
## Example
```sql
> USE db;
--SUCCEED: Database changed
> SHOW TABLE STATUS;
---------- ------------ --------------- -------------- ------ ------------------ ---------------- ----------- ------------------- --------- -------------- ---------------- ------------------- ----------
Table_id Table_name Database_name Storage_type Rows Memory_data_size Disk_data_size Partition Partition_unalive Replica Offline_path Offline_format Offline_deep_copy Warnings
---------- ------------ --------------- -------------- ------ ------------------ ---------------- ----------- ------------------- --------- -------------- ---------------- ------------------- ----------
6 t1 db memory 2 479 0 8 0 3 NULL NULL NULL
---------- ------------ --------------- -------------- ------ ------------------ ---------------- ----------- ------------------- --------- -------------- ---------------- ------------------- ----------
```