SHOW [FULL] TABLES

This statement shows a list of tables and views in the currently selected database. The optional keyword FULL indicates if a table is of type BASE TABLE, SEQUENCE, or VIEW.

To show tables in a different database, use SHOW TABLES IN DatabaseName.

Synopsis

ShowTableStmt

SHOW TABLES - 图1

ShowLikeOrWhere

SHOW TABLES - 图2

  1. ShowTableStmt ::=
  2.     "SHOW" "FULL"? "TABLES" ("FROM" Identifier | "IN" Identifier )? ShowLikeOrWhere?
  4. ShowLikeOrWhere ::=
  5.     "LIKE" SimpleExpr
  6. |   "WHERE" Expression

Examples

  1. mysql> CREATE TABLE t1 (a int);
  2. Query OK, 0 rows affected (0.12 sec)
  4. mysql> CREATE VIEW v1 AS SELECT 1;
  5. Query OK, 0 rows affected (0.10 sec)
  7. mysql> SHOW TABLES;
  8. +----------------+
  9. | Tables_in_test |
  10. +----------------+
  11. | t1             |
  12. | v1             |
  13. +----------------+
  14. 2 rows in set (0.00 sec)
  16. mysql> SHOW FULL TABLES;
  17. +----------------+------------+
  18. | Tables_in_test | Table_type |
  19. +----------------+------------+
  20. | t1             | BASE TABLE |
  21. | v1             | VIEW       |
  22. +----------------+------------+
  23. 2 rows in set (0.00 sec)
  25. mysql> SHOW TABLES IN mysql;
  26. +-------------------------+
  27. | Tables_in_mysql         |
  28. +-------------------------+
  29. | GLOBAL_VARIABLES        |
  30. | bind_info               |
  31. | columns_priv            |
  32. | db                      |
  33. | default_roles           |
  34. | expr_pushdown_blacklist |
  35. | gc_delete_range         |
  36. | gc_delete_range_done    |
  37. | global_priv             |
  38. | help_topic              |
  39. | opt_rule_blacklist      |
  40. | role_edges              |
  41. | stats_buckets           |
  42. | stats_feedback          |
  43. | stats_histograms        |
  44. | stats_meta              |
  45. | stats_top_n             |
  46. | tables_priv             |
  47. | tidb                    |
  48. | user                    |
  49. +-------------------------+
  50. 20 rows in set (0.00 sec)

MySQL compatibility

The SHOW [FULL] TABLES statement in TiDB is fully compatible with MySQL. If you find any compatibility differences, report a bug.

See also