> 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/system-tables/information-schema/information-schema-tables/information-schema-events-table.md). # Information Schema EVENTS Table The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `EVENTS` table stores information about [Events](/docs/server/server-usage/triggers-events/event-scheduler.md) on the server. It contains the following columns:

Column	Description
EVENT_CATALOG	Always def.
EVENT_SCHEMA	Database where the event was defined.
EVENT_NAME	Event name.
DEFINER	Event definer.
TIME_ZONE	Time zone used for the event's scheduling and execution, by default SYSTEM.
EVENT_BODY	SQL.
EVENT_DEFINITION	The SQL defining the event.
EVENT_TYPE	Either ONE TIME or RECURRING.
EXECUTE_AT	DATETIME when the event is set to execute, or NULL if recurring.
INTERVAL_VALUE	Numeric interval between event executions for a recurring event, or NULL if not recurring.
INTERVAL_FIELD	Interval unit (e.g., HOUR)
SQL_MODE	The SQL_MODE at the time the event was created.
STARTS	Start DATETIME for a recurring event, NULL if not defined or not recurring.
ENDS	End DATETIME for a recurring event, NULL if not defined or not recurring.
STATUS	One of ENABLED, DISABLED or /SLAVESIDE_DISABLED.
ON_COMPLETION	The ON COMPLETION clause, either PRESERVE or NOT PRESERVE .
CREATED	When the event was created.
LAST_ALTERED	When the event was last changed.
LAST_EXECUTED	When the event was last run.
EVENT_COMMENT	The comment provided in the CREATE EVENT statement, or an empty string if none.
ORIGINATOR	MariaDB server ID on which the event was created.
CHARACTER_SET_CLIENT	character_set_client system variable session value at the time the event was created.
COLLATION_CONNECTION	collation_connection system variable session value at the time the event was created.
DATABASE_COLLATION	Database collation with which the event is linked.

The [SHOW EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events.md) and [SHOW CREATE EVENT](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event.md) statements provide similar information. _{*This page is licensed: CC BY-SA / Gnu FDL*} {% @marketo/form formId="4316" %}