Syntax
------

DROP EVENT [IF EXISTS] event_name

Description
-----------

This statement drops the event named event_name. The event immediately ceases
being active, and is deleted completely from the server.

If the event does not exist, the error ERROR 1517 (HY000): Unknown event
'event_name' results. You can override this and cause the statement to
generate a NOTE for non-existent events instead by using IF EXISTS. See SHOW
WARNINGS.

This statement requires the EVENT privilege. In MySQL 5.1.11 and earlier, an
event could be dropped only by its definer, or by a user having the SUPER
privilege.

Examples
--------

DROP EVENT myevent3;

Using the IF EXISTS clause:

DROP EVENT IF EXISTS myevent3;
Query OK, 0 rows affected, 1 warning (0.01 sec)

SHOW WARNINGS;
+-------+------+-------------------------------+
| Level | Code | Message                       |
+-------+------+-------------------------------+
| Note  | 1305 | Event myevent3 does not exist |
+-------+------+-------------------------------+

URL: https://mariadb.com/kb/en/drop-event/