Retro Eye care Haitian Deep Dark Default

DROP READWRITE_SPLITTING RULE

Description

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

Syntax

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