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

Related links

• Reserved word