DROP SHADOW RULE

Description

The DROP SHADOW RULE syntax is used to drop shadow rules from the current database.

Syntax

DropShadowRule ::=
  'DROP' 'SHADOW' 'RULE' ifExists? ruleName (',' ruleName)*

ifExists ::=
  'IF' 'EXISTS'

ruleName ::=
  identifier

Supplement

• ifExists clause is used to avoid Shadow rule not exists error.

Example

• Drop shadow rule

DROP SHADOW RULE shadow_rule;

• Drop multiple shadow rules

DROP SHADOW RULE shadow_rule, shadow_rule_1;

• Drop shadow rule with ifExists clause

DROP SHADOW RULE IF EXISTS shadow_rule;

Reserved word

DROP, SHADOW, RULE, IF, EXISTS

Related links

• Reserved word