SHOW TABLES

Description

Shows the list of tables in the currently selected database.

Syntax

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

Examples

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