Retro Eye care Haitian Deep Dark Default

DROP SHADOW ALGORITHM

Description

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

Syntax

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