DROP CERTIFICATE statement

Drops a certificate from the database.

Syntax

DROP CERTIFICATE [ IF EXISTS ] certificate-name

Remarks

DROP CERTIFICATE deletes a certificate from the ISYSCERTIFICATE system table.

Use the IF EXISTS clause if you do not want an error returned when the DROP CERTIFICATE statement attempts to remove a certificate that does not exist.

Privileges

You must have the MANAGE CERTIFICATES system privilege.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

DROP CERTIFICATE mycert;