UNREGISTER STORAGE UNIT
语法用于从当前逻辑库中移除存储单元。
UnregisterStorageUnit ::=
'UNREGISTER' 'STORAGE' 'UNIT' ( 'IF' 'EXISTS' )? storageUnitName ( ',' storageUnitName )* ( 'IGNORE' 'SINGLE' 'TABLES' )?
storageUnitName ::=
identifier
UNREGISTER STORAGE UNIT
只会移除 Proxy 中的存储单元,不会删除与存储单元对应的真实数据源;Storage unit are still in used
;SINGLE TABLE RULE
,且用户确认可以忽略该限制时,可添加 IGNORE SINGLE TABLES
关键字移除存储单元。UNREGISTER STORAGE UNIT su_0;
UNREGISTER STORAGE UNIT su_1, su_2;
UNREGISTER STORAGE UNIT su_3 IGNORE SINGLE TABLES;
UNREGISTER STORAGE UNIT IF EXISTS su_4;
DROP
、STORAGE
、UNIT
、IF
、EXISTS
、IGNORE
、SINGLE
、TABLES