DROP DBEVENT
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP DBEVENT statement drops the specified database event.
The DROP DBEVENT statement has the following format:
[EXEC SQL] DROP DBEVENT [IF EXISTS] [schema.]event_name;
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist and the user matches the schema.
Embedded Usage
In an embedded DROP DBEVENT statement, event_name cannot be specified using a host string variable. Event_name can be specified as the target of a dynamic SQL statement string.
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
Last modified date: 08/14/2024