Mysql SHOW TABLE STATUS
command can be used to display information about all or specified tables in mysql db. Here are some examples:
Show status of all tables
SHOW TABLE STATUS
Here is the sample outcome
![mysql-show-table-status](https://infoheap.com/wp-content/uploads/2016/09/mysql-show-table-status.png)
Show table status of tables matching pattern in specific db
SHOW TABLE STATUS FROM db_name LIKE 'pattern' e.g. SHOW TABLE STATUS FROM mydb LIKE 'table_prefix%'