DROP SIGNATURE

Drop a digital signature from a stored procedure, function, trigger, or event notification.

Syntax
      DROP [COUNTER] SIGNATURE FROM module
         BY crypto_list [,...n]

   crypto_list:
       CERTIFICATE cert [WITH PASSWORD = 'password']
       CERTIFICATE cert WITH SIGNATURE = @cert_signature
       ASYMMETRIC KEY Asym_key [WITH PASSWORD = 'password']
       ASYMMETRIC KEY Asym_key WITH SIGNATURE = @asym_key_signature
	  
Key
   module         Stored procedure, function, trigger, or event notification.
   cert           The certificate used to sign the stored procedure, function..
   password       To decrypt the private key.
   cert_signature The certificate signature (binary).

Example

DROP SIGNATURE FROM MyDatabase.MyStoredproc
    BY CERTIFICATE MyCertificate;

"If only God would give me some clear sign! Like making a large deposit in my name at a Swiss bank" - Woody Allen

Related commands:

sys.crypt_properties
ADD SIGNATURE

Equivalent Oracle command:

ALTER USER USING AUTHENTICATION...