e>
mysql&gt; CREATE EVENT
  sakila.purge_history
ON SCHEDULE
  EVERY 1 DAY
ON COMPLETION PRESERVE
ENABLE
DO
  DELETE FROM sakila.rental WHERE rental_date < DATE(NOW() - INTERVAL 5 YEAR);
	
mysql&gt; call common_schema.get_event_dependencies('sakila', 'purge_history');
+-------------+-------------+-------------+--------+
| schema_name | object_name | object_type | action |
+-------------+-------------+-------------+--------+
| sakila      | rental      | table       | delete |
+-------------+-------------+--