DROP SYMMETRIC KEY

DROP a symmetric key from the database.

Syntax:
      DROP SYMMETRIC KEY key_name

   key_name
      Name of the asymmetric key to be dropped

If the key is open in the current session the drop will fail.

Requires CONTROL permission on the symmetric key.

Examples

CLOSE SYMMETRIC KEY MySymKey01;
DROP SYMMETRIC KEY MySymKey01;

"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 SYMMETRIC KEY
CREATE SYMMETRIC KEY
ALTER SYMMETRIC KEY DROP ENCRYPTION (remove encryption by an asymmetric key)