9. Ensuring Data Integrity : Database Events : How Database Events Work : Remove an Event Registration
 
Share this page                  
Remove an Event Registration
To remove a database event registration, use the REMOVE DBEVENT statement from interactive or embedded SQL applications or from within a database procedure.
Using REMOVE DBEVENT simply “unregisters” an application for a particular database event. The event is still defined for the database and can be received by other applications that are still registered.
After an event registration is removed, the DBMS does not notify the application when the specified event is raised. Pending event messages are not removed from the event queue.
For the complete statement syntax and additional information about using the REMOVE DBEVENT statement, see the SQL Reference Guide.
Drop Database Events
You can drop a dbevent object from the database, in which case it cannot be raised and applications cannot register to receive it. Pending event messages are not removed from the event queue.
If an event is dropped while applications are registered to receive it, the event registrations are not dropped until each application disconnects from the database or removes its registration for the dropped event. If the event is recreated (with the same name), it can again be received by registered applications.