SHOW UNLOADED SINGLE TABLES 语法用于查询未加载的单表。
showUnloadedSingleTables::=
'SHOW' 'UNLOADED' 'SINGLE' 'TABLES' ('FROM' fromClause)?
fromClause ::=
databaseName ('STORAGE' 'UNIT' storageUnitName ('SCHEMA' schemaName)?)?
| 'STORAGE' 'UNIT' storageUnitName ('SCHEMA' schemaName)?
| 列 | 说明 |
|---|---|
| table_name | 单表名称 |
| storage_unit_name | 单表所在的存储单元名称 |
| schema_name | Schema 名称，仅在存在 Schema 元数据时返回 |
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 FROM STORAGE UNIT ds_0;
SHOW、UNLOADED、SINGLE、TABLES、FROM、STORAGE、UNIT、SCHEMA