SHOW [FULL] TABLES

SHOW [FULL] TABLES 语句用于显示当前所选数据库中表和视图的列表。可选关键字 FULL 说明表的类型是 BASE TABLE 还是 VIEW。

若要在不同的数据库中显示表，可使用 SHOW TABLES IN DatabaseName 语句。

语法图

ShowTablesStmt:

ShowTablesStmt

OptFull:

OptFull

ShowDatabaseNameOpt:

ShowDatabaseNameOpt

ShowLikeOrWhereOpt:

ShowLikeOrWhereOpt

示例

  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 兼容性

SHOW [FULL] TABLES 语句与 MySQL 完全兼容。如发现任何兼容性差异，请在 GitHub 上提交 issue。

另请参阅