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)* ignoreTables?

ifExists ::=
  'IF' 'EXISTS'

storageUnitName ::=
  identifier

ignoreTables ::=
  'IGNORE' ('SINGLE')? (',')? ('BROADCAST')? 'TABLES'

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 RULE, BROADCAST RULE and when the user confirms that this restriction can be ignored, the IGNORE SINGLE TABLES, IGNORE BROADCAST TABLES, IGNORE SINGLE, BROADCAST TABLES keyword can be added to remove the storage unit;
  • ifExists clause is used for avoid Storage unit not exists error.

Example

  • Unregister a storage unit
UNREGISTER STORAGE UNIT ds_0;
  • Unregister multiple storage units
UNREGISTER STORAGE UNIT ds_0, ds_1;
  • Unregister storage unit and ignore single tables
UNREGISTER STORAGE UNIT ds_0 IGNORE SINGLE TABLES;
  • Unregister storage unit and ignore broadcast tables
UNREGISTER STORAGE UNIT ds_0 IGNORE BROADCAST TABLES;
  • Unregister storage unit, ignore single and broadcast tables
UNREGISTER STORAGE UNIT ds_0 IGNORE SINGLE, BROADCAST TABLES;
  • Unregister storage unit with ifExists clause
UNREGISTER STORAGE UNIT IF EXISTS ds_0;

Reserved word

UNREGISTER, STORAGE, UNIT, IF, EXISTS, IGNORE, SINGLE, BROADCAST, TABLES