The SHOW UNLOADED SINGLE TABLES syntax is used to query unloaded single tables.
showUnloadedSingleTables::=
'SHOW' 'UNLOADED' 'SINGLE' 'TABLES'
| Column | Description |
|---|---|
| table_name | Single table name |
| storage_unit_name | The storage unit name where the single table is located |
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