DROP ENCRYPTKEY

Description

Syntax

1. DROP ENCRYPTKEY key_name

Parameters

key_name: To delete the name of the key, you can include the name of the database. For example: db1.my_key.

Delete a custom key. A key can be deleted only if its name is identical.

Executing this command requires the user to have the ADMIN privileges.

example

1. Delete a key.

1. DROP ENCRYPTKEY my_key;

keyword

1. DROP,ENCRYPTKEY