DROP ASYMMETRIC KEY

DROP an asymmetric key from the database.

Syntax:
      DROP ASYMMETRIC KEY key_name


   key_name
      Name of the asymmetric key to be dropped

If the key has been used to encrypt a symmetric key (or map a user/login), you must drop the user/login and the symmetric key before dropping the asymmetric key.

Requires CONTROL permission on the asymmetric key.

Examples

USE MyDatabase;
DROP ASYMMETRIC KEY MyAsymKey01;

"Success is not the key to happiness. Happiness is the key to success. If you love what you are doing, you will be successful” ~ Herman Cain

Related commands

ALTER ASYMMETRIC KEY
CREATE ASYMMETRIC KEY
ALTER SYMMETRIC KEY DROP ENCRYPTION (remove encryption by an asymmetric key)