DROP ENCRYPT RULE

Description

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

Syntax

Grammar Railroad diagram

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

Supplement

• ifExists clause is used for 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