Retro Eye care Haitian Deep Dark Default

UNREGISTER STORAGE UNIT

Description

The UNREGISTER STORAGE UNIT syntax is used to unregister storage unit from the current database

Syntax

UnregisterStorageUnit ::=
  'UNREGISTER' 'STORAGE' 'UNIT' ifExists? storageUnitName (',' storageUnitName)* ('IGNORE' 'SINGLE' 'TABLES')?

ifExists ::=
  'IF' 'EXISTS'

storageUnitName ::=
  identifier

Supplement

  • UNREGISTER STORAGE UNIT will only unregister storage unit in Proxy, the real data source corresponding to the storage unit will not be unregistered;
  • Unable to unregister storage unit already used by rules. Storage unit are still in used. will be prompted when removing storage units used by rules;
  • The storage unit need to be removed only contains SINGLE TABLE RULE, and when the user confirms that this restriction can be ignored, the IGNORE SINGLE TABLES keyword can be added to remove the storage unit;
  • ifExists clause is used for avoid Storage unit not exists error.

Example

  • Drop a storage unit
UNREGISTER STORAGE UNIT ds_0;
  • Drop multiple storage units
UNREGISTER STORAGE UNIT ds_0, ds_1;
  • Ignore single table rule remove storage unit
UNREGISTER STORAGE UNIT ds_0 IGNORE SINGLE TABLES;
  • Drop the storage unit with ifExists clause
UNREGISTER STORAGE UNIT IF EXISTS ds_0;

Reserved word

DROP, STORAGE, UNIT, IF, EXISTS, IGNORE, SINGLE, TABLES