DROP READWRITE_SPLITTING RULE

Description

The DROP READWRITE_SPLITTING RULE syntax is used to drop readwrite-splitting rules from the current database.

Syntax

DropReadwriteSplittingRule ::=
  'DROP' 'READWRITE_SPLITTING' 'RULE' ifExists? ruleName (',' ruleName)*

ifExists ::=
  'IF' 'EXISTS'

ruleName ::=
  identifier

Supplement

• ifExists clause is used to avoid Readwrite-splitting rule not exists error.

Example

• Drop readwrite-splitting rule

DROP READWRITE_SPLITTING RULE ms_group_1;

• Drop multiple readwrite-splitting rules

DROP READWRITE_SPLITTING RULE ms_group_1, ms_group_2;

• Drop readwrite-splitting rule with ifExists clause

DROP READWRITE_SPLITTING RULE IF EXISTS ms_group_1;

Reserved word

DROP, READWRITE_SPLITTING, RULE, IF, EXISTS

Related links

• Reserved word