SQL Language Guide : 7. SQL Statements : DROP DBEVENT
 
Share this page                  
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;