The SHOW UNLOADED SINGLE TABLES syntax is used to query unloaded single tables.
showUnloadedSingleTables::=
'SHOW' 'UNLOADED' 'SINGLE' 'TABLES' ('FROM' fromClause)?
fromClause ::=
databaseName ('STORAGE' 'UNIT' storageUnitName ('SCHEMA' schemaName)?)?
| 'STORAGE' 'UNIT' storageUnitName ('SCHEMA' schemaName)?
| Column | Description |
|---|---|
| table_name | Single table name |
| storage_unit_name | The storage unit name where the single table is located |
| schema_name | Schema name, returned only when schema metadata exists |
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