Retro Eye care Haitian Deep Dark Default

DROP SHARDING TABLE REFERENCE RULE

Description

The DROP SHARDING TABLE REFERENCE RULE syntax is used to drop specified sharding table reference rule.

Syntax

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

ifExists ::=
  'IF' 'EXISTS'

ruleName ::=
  identifier

Supplement

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

Example

  • Drop a specified sharding table reference rule
DROP SHARDING TABLE REFERENCE RULE ref_0;
  • Drop multiple sharding table reference rules
DROP SHARDING TABLE REFERENCE RULE ref_0, ref_1;
  • Drop sharding table reference rule with ifExists clause
DROP SHARDING TABLE REFERENCE RULE IF EXISTS ref_0;

Reserved word

DROP, SHARDING, TABLE, REFERENCE, RULE