Syntax\n------\n\nSHOW EVENTS [{FROM | IN} schema_name]\n    [LIKE 'pattern' | WHERE expr]\n\nDescription\n-----------\n\nShows information about Event Manager events (created with CREATE EVENT). Requires the EVENT privilege. Without any arguments, SHOW EVENTS lists all of the events in the current schema:\n\n``sql\nSELECT CURRENT_USER(), SCHEMA();\n+----------------+----------+\n| CURRENT_USER() | SCHEMA() |\n+----------------+----------+\n| jon@ghidora    | myschema |\n+----------------+----------+\n\nSHOW EVENTS\\G\n************************ 1. row ************************\n                  Db: myschema\n                Name: e_daily\n             Definer: jon@ghidora\n           Time zone: SYSTEM\n                Type: RECURRING\n          Execute at: NULL\n      Interval value: 10\n      Interval field: SECOND\n              Starts: 2006-02-09 10:41:23\n                Ends: NULL\n              Status: ENABLED\n          Originator: 0\ncharacter_set_client: latin1\ncollation_connection: latin1_swedish_ci\n  Database Collation: latin1_swedish_ci\n`\n\nTo see the event action, use SHOW CREATE EVENT instead, or look at the information_schema.EVENTS table.\n\nTo see events for a specific schema, use the FROM clause. For example, to see events for the test schema, use the following statement:\n\n`sql\nSHOW EVENTS FROM test;\n`\n\nThe LIKE clause, if present, indicates which event names to match. The WHERE` clause can be given to select rows using more general conditions, as discussed in Extended Show.\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events