DROP CERTIFICATE

Remove a certificate from the database.

Syntax:
      DROP CERTIFICATE certificate_name


   certificate_name
      Name of the certificate

Certificates can only be dropped if no entities are associated with them.

Requires CONTROL permission on the certificate.

Examples

USE MyDatabase;
DROP CERTIFICATE MyCert01;

"To fight and conquer in all your battles is not supreme excellence; supreme excellence consists in breaking the enemy's resistance without fighting” ~ Sun Tzu

Related commands

CREATE CERTIFICATE
ALTER CERTIFICATE
BACKUP CERTIFICATE