Use this statement to drop an event from the database.

Syntax

DROP EVENT [ IF EXISTS ] [ owner.]event-name 

Remarks

Use the IF EXISTS clause if you do not want an error returned when the DROP EVENT statement attempts to remove an event that does not exist.

Permissions

Any user who owns the object, or has DBA authority, can execute the DROP EVENT statement.

Side effects

Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.

See also

• CREATE EVENT statement
• ALTER EVENT statement
• TRIGGER EVENT statement

Standards and compatibility

Example

Drop MyEvent from the database. If the event does not exist, an error is returned.

DROP EVENT MyEvent;