DROP-ENCRYPT-KEY

Name

DROP ENCRYPTKEY

Description

Syntax:

DROP ENCRYPTKEY key_name

Parameter Description:

• key_name: the name of the key to be deleted. It can include the name of the database, for example, db1.my_key.

If you are to delete a custom key, please make sure the key name is exactly correct.

Executing this command requires the user to have ADMIN privileges.

Example

1. Delete a key

   DROP ENCRYPTKEY my_key;

Keywords

 DROP, ENCRYPT, KEY

Best Practice