The UNREGISTER STORAGE UNIT
syntax is used to unregister storage unit from the current database
UnregisterStorageUnit ::=
'UNREGISTER' 'STORAGE' 'UNIT' ('IF' 'EXISTS')? storageUnitName (',' storageUnitName)* ('IGNORE' 'SINGLE' 'TABLES')?
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 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.UNREGISTER STORAGE UNIT ds_0;
UNREGISTER STORAGE UNIT ds_0, ds_1;
UNREGISTER STORAGE UNIT ds_0 IGNORE SINGLE TABLES;
UNREGISTER STORAGE UNIT IF EXISTS ds_0;
DROP
, STORAGE
, UNIT
, IF
, EXISTS
, IGNORE
, SINGLE
, TABLES