Retro Eye care Haitian Deep Dark Default

DROP SHARDING TABLE RULE

Description

The DROP SHARDING TABLE RULE syntax is used to drop sharding table rules from the current database.

Syntax

DropShardingTableRule ::=
  'DROP' 'SHARDING' 'TABLE' 'RULE' ifExists? ruleName (',' ruleName)*

ifExists ::=
  'IF' 'EXISTS'

ruleName ::=
  identifier

Supplement

  • ifExists clause is used to avoid Sharding rule not exists error.

Example

  • Drop multiple sharding table rules
DROP SHARDING TABLE RULE t_order, t_order_item;
  • Drop a sharding table rule
DROP SHARDING TABLE RULE t_order;
  • Drop sharding table rule with ifExists clause
DROP SHARDING TABLE RULE IF EXISTS t_order;

Reserved word

DROP, SHARDING, TABLE, RULE, IF, EXISTS