OR 11.2 | Drop Dbevent Statement

Language Reference Guide > Language Reference Guide > Statements > OpenROAD SQL Statements > Drop Dbevent Statement

Was this helpful?

Drop Dbevent Statement

The drop dbevent statement drops the specified database event.

This statement has the following syntax:

drop dbevent [schema.]event_name;

Parameters--Drop Dbevent Statement

This statement has the following parameter:

event_name

Specifies the name of the event to drop.

Drop Dbevent 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.

Drop Dbevent Related Statements

Create Dbevent Statement

Grant (privilege) Statement

Raise Dbevent Statement

Examples--Drop Dbevent Statement

The following statement deletes the drill_hot dbevent:

drop dbevent drill_hot;

Last modified date: 12/20/2023