drop encryption key drops the key copies when you drop the base key. The key owner and the SSO can drop encryption keys. The command fails if any column in any database is encrypted using the key.
The syntax is:
drop encryption key [database.[owner].]keyname
