drop encryption key

Deletes the database encryption key from the sysencryptkeys table in the master database.

Syntax

drop encryption key key_name

This command fails if the database encryption key you are dropping is still used to encrypt any database.

ANSI SQL – Compliance level: Transact-SQL extension.

The permission checks for drop encryption key differ, based on your granular permission settings:

Granular permissions enabled	SAP ASE creates a new permission called "`manage database encryption key`." You must have this permission to create a database encryption key.
Granular permissions disabled	You must be a user with sso_role, keycustodian_role, or have create encryption key privilege.