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.
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
ALTER ASYMMETRIC KEY
CREATE ASYMMETRIC KEY
ALTER SYMMETRIC KEY DROP ENCRYPTION (remove encryption by an asymmetric key)
© Copyright SS64.com 1999-2013
Some rights reserved