Retro Eye care Haitian Deep Dark Default

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