Retro Eye care Haitian Deep Dark Default

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 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