To drop the database encryption key, use the drop encryption key
command. This command deletes the database encryption key from the
sysencryptkeys table in the master database.
The syntax
is:
drop encryption key key_name
Note: This
command fails if the database encryption key you are dropping is still being used to
encrypt a database.