DROP MASK RULE

Description

The DROP MASK RULE syntax is used to drop existing mask rule.

Syntax

DropMaskRule ::=
  'DROP' 'MASK' 'TABLE'? 'RULE' ifExists? ruleName (',' ruleName)*

ifExists ::=
  'IF' 'EXISTS'

ruleName ::=
  identifier

Supplement

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

Example

• Drop mask rule

DROP MASK RULE t_mask, t_mask_1;

• Drop mask rule with ifExists clause

DROP MASK RULE IF EXISTS t_mask, t_mask_1;

Reserved words

DROP, MASK, TABLE, RULE

Related links

• Reserved word