DROP DBEVENT¶

Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET

The DROP DBEVENT statement drops the specified database event.

Syntax¶

The DROP DBEVENT statement has the following format:

[EXEC SQL] DROP DBEVENT [schema.]event_name;

Permissions¶

You must be the owner of a database event. If applications are currently registered to receive the database event, the registrations are not dropped. If the database event was raised prior to being dropped, the database event notifications remain queued, and applications can receive them using the GET DBEVENT statement.

Related Statements¶

CREATE DBEVENT

GRANT (privilege)

RAISE DBEVENT

REGISTER DBEVENT

REMOVE DBEVENT

DROP DBEVENT Example¶

Delete the drill_hot dbevent:

DROP DBEVENT drill_hot;