DROP SHADOW ALGORITHM

Description

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

Syntax

Grammar Railroad diagram

  1. DropShadowAlgorithm ::=
  2.   'DROP' 'SHADOW' 'ALGORITHM' ifExists? algorithmName (',' algorithmName)* ('FROM' databaseName)?
  4. ifExists ::=
  5.   'IF' 'EXISTS'
  7. algorithmName ::=
  8.   identifier
  10. databaseName ::=
  11.   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
  1. 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
  1. DROP SHADOW ALGORITHM shadow_rule_t_order_sql_hint_0;
  • Drop shadow algorithm with ifExists clause
  1. DROP SHADOW ALGORITHM IF EXISTS shadow_rule_t_order_sql_hint_0;

Reserved word

DROP, SHODOW, ALGORITHM, FROM