DROP SHARDING TABLE RULE 语法用于从当前逻辑库中删除分片表规则。
DropShardingTableRule ::=
'DROP' 'SHARDING' 'TABLE' 'RULE' ifExists? ruleName (',' ruleName)*
ifExists ::=
'IF' 'EXISTS'
ruleName ::=
identifier
ifExists 子句用于避免 Sharding rule not exists 错误。DROP SHARDING TABLE RULE t_order, t_order_item;
DROP SHARDING TABLE RULE t_order;
ifExists 子句删除分片规则DROP SHARDING TABLE RULE IF EXISTS t_order;
DROP、SHARDING、TABLE、RULE、IF、EXISTS