Retro Eye care Haitian Deep Dark Default

DROP SHADOW ALGORITHM

Description

The DROP SHADOW ALGORITHM syntax is used to drop shadow algorithms from the current database.

Syntax

DropShadowAlgorithm ::=
  'DROP' 'SHADOW' 'ALGORITHM' ifExists? algorithmName (',' algorithmName)*

ifExists ::=
  'IF' 'EXISTS'

algorithmName ::=
  identifier

Supplement

  • ifExists clause is used to avoid shadow algorithm not exists error.

Example

  • Drop multiple shadow algorithms
DROP SHADOW ALGORITHM shadow_rule_t_order_sql_hint_0, shadow_rule_t_order_item_sql_hint_0;
  • Drop a shadow algorithm
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, SHADOW, ALGORITHM, IF, EXISTS