> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/data-definition/drop/drop-event.md).

# DROP EVENT

## Syntax

```bnf
DROP EVENT [IF EXISTS] event_name
```

## Description

This statement drops the [event](/docs/server/server-usage/triggers-events/event-scheduler/events.md) 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](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-warnings.md).

This statement requires the [EVENT](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#database-privileges) privilege.

## Examples

```sql
DROP EVENT myevent3;
```

Using the IF EXISTS clause:

```sql
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 |
+-------+------+-------------------------------+
```

## See also

* [Events Overview](/docs/server/server-usage/triggers-events/event-scheduler/events.md)
* [CREATE EVENT](/docs/server/reference/sql-statements/data-definition/create/create-event.md)
* [SHOW CREATE EVENT](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event.md)
* [ALTER EVENT](/docs/server/server-usage/triggers-events/event-scheduler/alter-event.md)

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}