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. +---------------+