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