SHOW UNLOADED SINGLE TABLES

Description

The SHOW UNLOADED SINGLE TABLES syntax is used to query unloaded single tables.

Syntax

Grammar Railroad diagram

  1. showUnloadedSingleTables::=
  2.   'SHOW' 'UNLOADED' 'SINGLE' 'TABLES'

Return value description

ColumnDescription
table_nameSingle table name
storage_unit_nameThe storage unit name where the single table is located

Example

  • Query unloaded single tables.
  1. SHOW UNLOADED SINGLE TABLES;
  1. mysql> SHOW UNLOADED SINGLE TABLES;
  2. +------------+-------------------+
  3. | table_name | storage_unit_name |
  4. +------------+-------------------+
  5. | t_single   | ds_1              |
  6. +------------+-------------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, UNLOADED, SINGLE, TABLES