|
|
|
Valid in: SQL, ESQL
The Drop Dbevent statement drops the specified database event.
|
|
|
The Drop Dbevent statement has the following format:
[EXEC SQL] DROP DBEVENT [schema.]event_name;
|
|
|
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.
|
|
|
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.
|
|
|
|
|
|
The following example deletes the specified location:
drop location extra_work_disk;