SHOW-TABLES

Name

SHOW TABLES

Description

该语句用于展示当前 db 下所有的 table

语法：

1. SHOW TABLES [LIKE]

说明:

1. LIKE：可按照表名进行模糊查询

Example

1. 查看DB下所有表

1. mysql> show tables; 2. +---------------------------------+ 3. | Tables_in_demo | 4. +---------------------------------+ 5. | ads_client_biz_aggr_di_20220419 | 6. | cmy1 | 7. | cmy2 | 8. | intern_theme | 9. | left_table | 10. +---------------------------------+ 11. 5 rows in set (0.00 sec) 2. 按照表名进行模糊查询

1. mysql> show tables like '%cm%'; 2. +----------------+ 3. | Tables_in_demo | 4. +----------------+ 5. | cmy1 | 6. | cmy2 | 7. +----------------+ 8. 2 rows in set (0.00 sec)

Keywords

1. SHOW, TABLES

Best Practice