DROP ASSERTION

Purpose

Prerequisites

You must have the DROP ANY ASSERTION [ ON SCHEMA …] privilege to drop assertions in the specified schema or any other schema not your own.

Syntax


Description of drop_assertion.eps follows
Description of the illustration drop_assertion.eps

Semantics

IF EXISTS

Specify IF EXISTS to prevent an error message in case the SQL assertion you are trying to drop does not exist.

You cannot use IF NOT EXISTS with DROP statements.

Examples

Example 1: Dropping an assertion

The following statement removes the assertion company_must_have_a_president: 

DROP ASSERTION IF EXISTS company_must_have_a_president;

If there is no assertion with this name, the statement takes no action and completes without error.

Example 1: Dropping an assertion in another schema

The following statement drops the assertion salary_within_job_limit in the HR schema: 

DROP ASSERTION hr.salary_within_job_limit;

If you're not connected as the HR user, your user must have either of these privileges:

DROP ANY ASSERTION or DROP ANY ASSERTION ON SCHEMA hr.