SHOW [FULL] TABLES

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

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

语法图

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

示例

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 完全兼容。如发现任何兼容性差异，请尝试 TiDB 支持资源。

另请参阅