SHOW UNLOADED SINGLE TABLES 语法用于查询未加载的单表。
showUnloadedSingleTables::=
'SHOW' 'UNLOADED' 'SINGLE' 'TABLES'
| 列 | 说明 |
|---|---|
| table_name | 单表名称 |
| storage_unit_name | 单表所在的存储单元名称 |
SHOW UNLOADED SINGLE TABLES;
mysql> SHOW UNLOADED SINGLE TABLES;
+------------+-------------------+
| table_name | storage_unit_name |
+------------+-------------------+
| t_single | ds_1 |
+------------+-------------------+
1 row in set (0.01 sec)
SHOW、UNLOADED、SINGLE、TABLES