DROP SHARDING TABLE RULE
语法用于删除指定逻辑库的指定分片规则
DropShardingTableRule ::=
'DROP' 'SHARDING' 'TABLE' 'RULE' shardingRuleName (',' shardingRuleName)* ('FROM' databaseName)?
shardingRuleName ::=
identifier
databaseName ::=
identifier
databaseName
时,默认是当前使用的 DATABASE
。 如果也未使用 DATABASE
则会提示 No database selected
。DROP SHARDING TABLE RULE t_order, t_order_item FROM test1;
DROP SHARDING TABLE RULE t_order;
DROP
、SHARDING
、TABLE
、RULE
、FROM