DROP SHADOW ALGORITHM

Description

The DROP SHADOW ALGORITHM syntax is used to drop shadow algorithm for specified database

Syntax

Grammar Railroad diagram

DropShadowAlgorithm ::=
  'DROP' 'SHADOW' 'ALGORITHM' ifExists? shadowAlgorithmName (',' shadowAlgorithmName)* ('FROM' databaseName)?
ifExists ::=
  'IF' 'EXISTS'
shadowAlgorithmName ::=
  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 shadow algorithm not exists error.

Example

• Drop mutiple shadow algorithm for specified database

DROP SHADOW ALGORITHM shadow_rule_t_order_sql_hint_0, shadow_rule_t_order_item_sql_hint_0 FROM shadow_db;

• Drop single shadow algorithm for current database

DROP SHADOW ALGORITHM shadow_rule_t_order_sql_hint_0;

• Drop shadow algorithm with ifExists clause

DROP SHADOW ALGORITHM IF EXISTS shadow_rule_t_order_sql_hint_0;

Reserved word

DROP, SHODOW, ALGORITHM, FROM

Related links

• Reserved word