DROP SHADOW ALGORITHM

Description

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

Syntax

DropShadowAlgorithm ::=
  'DROP' 'SHADOW' 'ALGORITHM' shadowAlgorithmName(',' shadowAlgorithmName)* ('FROM' databaseName)?
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.

Example

• Drop mutiple shadow algorithm for specified database

DROP SHADOW ALGORITHM shadow_rule_t_order_simple_hint_0, shadow_rule_t_order_item_simple_hint_0 FROM test1;

• Drop single shadow algorithm for current database

DROP SHADOW ALGORITHM shadow_rule_t_order_simple_hint_0;

Reserved word

DROP, SHODOW, ALGORITHM, FROM

Related links

• Reserved word