SHOW TABLES

语法说明

以列表的形式展现当前数据库创建的所有表。

语法结构

1. > SHOW TABLES  [LIKE 'pattern' | WHERE expr | FROM 'pattern' | IN 'pattern']

示例

1. > SHOW TABLES;
2. +---------------+
3. | name          |
4. +---------------+
5. | clusters      |
6. | contributors  |
7. | databases     |
8. | functions     |
9. | numbers       |
10. | numbers_local |
11. | numbers_mt    |
12. | one           |
13. | processes     |
14. | settings      |
15. | tables        |
16. | tracing       |
17. +---------------+