DROP DIRECTIVE (NOTIFY)

Purpose

Use DROP DIRECTIVE to drop a notification directive. This statement also drops its notification table and notification view, whether the base object is a table or a JSON-relational duality view.

Prerequisites

The notification directive must be in your schema, or you must have the DROP ANY NOTIFICATION DIRECTIVE system privilege.

Syntax

drop_directive_notify::=

Description of the illustration drop_directive_notify.gif

Semantics

Dropping a notification directive drops the associated notification table and notification view, whether the directive is on a table or a JSON-relational duality view.

Examples

The following statement drops the emp_ndrtv notification directive on the scott.emp table:

DROP DIRECTIVE scott.emp_ndrtv;