DROP READWRITE_SPLITTING RULE

Description

The DROP READWRITE_SPLITTING RULE syntax is used to drop readwrite splitting rule for specified database

Syntax

Grammar Railroad diagram

DropReadwriteSplittingRule ::=
  'DROP' 'READWRITE_SPLITTING' 'RULE' ifExists? readwriteSplittingRuleName (',' readwriteSplittingRuleName)* ('FROM' databaseName)?
ifExists ::=
  'IF' 'EXISTS'
readwriteSplittingRuleName ::=
  identifier
databaseName ::=
  identifier

Supplement

• When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted;
• ifExists clause is used for avoid Readwrite splitting rule not exists error.

Example

• Drop readwrite splitting rule for specified database

DROP READWRITE_SPLITTING RULE ms_group_1 FROM readwrite_splitting_db;

• Drop readwrite splitting rule for current database

DROP READWRITE_SPLITTING RULE ms_group_1;

• Drop readwrite splitting rule with ifExists clause

DROP READWRITE_SPLITTING RULE IF EXISTS ms_group_1;

Reserved word

DROP, READWRITE_SPLITTING, RULE

Related links

• Reserved word