The UNREGISTER STORAGE UNIT
syntax is used to unregister storage unit from the current database
UnregisterStorageUnit ::=
'UNREGISTER' 'STORAGE' 'UNIT' ifExists? storageUnitName (',' storageUnitName)* (ignoreSingleTables | ignoreBroadcastTables | ignoreSingleAndBroadcastTables)?
ignoreSingleTables ::=
'IGNORE' 'SINGLE' 'TABLES'
ignoreBroadcastTables ::=
'IGNORE' 'BROADCAST' 'TABLES'
ignoreSingleAndBroadcastTables ::=
'IGNORE' ('SINGLE' ',' 'BROADCAST' | 'BROADCAST' ',' 'SINGLE') 'TABLES'
ifExists ::=
'IF' 'EXISTS'
storageUnitName ::=
identifier
UNREGISTER STORAGE UNIT
will only unregister storage unit in Proxy, the real data source corresponding to the storage unit will not be
unregistered;Storage unit are still in used.
will be prompted when removing
storage units used by rules;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.UNREGISTER STORAGE UNIT ds_0;
UNREGISTER STORAGE UNIT ds_0, ds_1;
UNREGISTER STORAGE UNIT ds_0 IGNORE SINGLE TABLES;
UNREGISTER STORAGE UNIT ds_0 IGNORE BROADCAST TABLES;
UNREGISTER STORAGE UNIT ds_0 IGNORE SINGLE, BROADCAST TABLES;
ifExists
clauseUNREGISTER STORAGE UNIT IF EXISTS ds_0;
DROP
, STORAGE
, UNIT
, IF
, EXISTS
, IGNORE
, SINGLE
, BROADCAST
, TABLES