UNREGISTER STORAGE UNIT :: ShardingSphere

UNREGISTER STORAGE UNIT

Description

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

Syntax

UnregisterStorageUnit ::=
  'UNREGISTER' 'STORAGE' 'UNIT' ifExists? storageUnitName (',' storageUnitName)* ignoreTables?

ifExists ::=
  'IF' 'EXISTS'

storageUnitName ::=
  identifier

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

Supplement

UNREGISTER STORAGE UNIT only unregisters storage units in Proxy. The real data sources corresponding to the storage units are not unregistered;
Storage units already used by rules can not be unregistered. Storage unit '%s' still used by '%s'. will be prompted when unregistering storage units used by rules;
When the storage units to be unregistered are only used by single table rules or broadcast rules, and the user confirms that this restriction can be ignored, IGNORE SINGLE TABLES, IGNORE BROADCAST TABLES, IGNORE SINGLE, BROADCAST TABLES, or IGNORE BROADCAST, SINGLE TABLES can be added to unregister the storage units;
ifExists clause is used to 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, ignore broadcast and single tables

UNREGISTER STORAGE UNIT ds_0 IGNORE BROADCAST, SINGLE 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

Reserved word