SHOW DEFAULT SINGLE TABLE STORAGE UNIT

Description

The SHOW DEFAULT SINGLE TABLE STORAGE UNIT syntax is used to query storage units for specified database.

Syntax

Grammar Railroad diagram

  1. ShowDefaultSingleTableStorageUnit::=
  2.   'SHOW' 'DEFAULT' 'SINGLE' 'TABLE' 'STORAGE' 'UNIT' ('FROM' databaseName)?
  4. databaseName ::=
  5.   identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return Value Description

ColumnDescription
storage_unit_nameStorage unit name

Example

  • Query storage units for specified database.
  1. SHOW DEFAULT SINGLE TABLE STORAGE UNIT
  1. sql> SHOW DEFAULT SINGLE TABLE STORAGE UNIT;
  2. +-------------------+
  3. | storage_unit_name |
  4. +-------------------+
  5. |  ds_0             |
  6. +-------------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, DEFAULT, SINGLE, TABLE, STORAGE, UNIT