DROP ENCRYPT RULE

Description

The DROP ENCRYPT RULE syntax is used to drop an existing encryption rule.

Syntax

DropEncryptRule ::=
  'DROP' 'ENCRYPT' 'RULE' ifExists? ruleName (',' ruleName)*

ifExists ::=
  'IF' 'EXISTS'

ruleName ::=
  identifier

Supplement

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

Example

• Drop an encrypt rule

DROP ENCRYPT RULE t_encrypt, t_encrypt_2;

• Drop encrypt with ifExists clause

DROP ENCRYPT RULE IF EXISTS t_encrypt, t_encrypt_2;

Reserved words

DROP, ENCRYPT, RULE

Related links

• Reserved word