## Notes 

• SAVEPOINTS 

Whether the storage engine supports savepoints. 

• ENGINES  is a nonstandard INFORMATION_SCHEMA  table. 

Storage engine information is also available from the SHOW ENGINES  statement. See Section 13.7.7.16, “SHOW ENGINES Statement” . The following statements are equivalent: 

## 26.3.14 The INFORMATION_SCHEMA EVENTS Table 

SELECT * FROM INFORMATION_SCHEMA.ENGINES SHOW ENGINES 

The EVENTS  table provides information about Event Manager events, which are discussed in Section 25.4, “Using the Event Scheduler” . 

The EVENTS  table has these columns: 

• EVENT_CATALOG 

The name of the catalog to which the event belongs. This value is always def . 

• EVENT_SCHEMA 

The name of the schema (database) to which the event belongs. 

• EVENT_NAME 

The name of the event. 

• DEFINER 

The account named in the DEFINER  clause (often the user who created the event), in ’ user_name ’@’ host_name ’  format. 

• TIME_ZONE 

The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. The default value is SYSTEM . 

• EVENT_BODY 

The language used for the statements in the event’s DO  clause. The value is always SQL . 

• EVENT_DEFINITION 

The text of the SQL statement making up the event’s DO  clause; in other words, the statement executed by this event. 

• EVENT_TYPE 

The event repetition type, either ONE TIME  (transient) or RECURRING  (repeating). 

• EXECUTE_AT 

