The SHOW DEFAULT SINGLE TABLE STORAGE UNIT syntax is used to query storage units for specified database.
ShowDefaultSingleTableStorageUnit::=
'SHOW' 'DEFAULT' 'SINGLE' 'TABLE' 'STORAGE' 'UNIT' ('FROM' databaseName)?
databaseName ::=
identifier
databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.| Column | Description |
|---|---|
| storage_unit_name | Storage unit name |
SHOW DEFAULT SINGLE TABLE STORAGE UNIT
sql> SHOW DEFAULT SINGLE TABLE STORAGE UNIT;
+-------------------+
| storage_unit_name |
+-------------------+
| ds_0 |
+-------------------+
1 row in set (0.01 sec)
SHOW, DEFAULT, SINGLE, TABLE, STORAGE, UNIT