I am trying to query existing triggers and their event_manipulation type.
I am looking in information_schema.triggers and see which triggers are fired before truncate operation on a table. event_manipulation, action_timing, and action_orientation gives me information like a trigger fired before/after, delete/insert/update and row/statement level. There is no information if the trigger fires for truncate. I verified for the trigger that was not showing truncate, it is defined to fire before truncate.
In the manual it says "Event that fires the trigger (INSERT, UPDATE, or DELETE)" for event_manipulation column description.
Is there any other information_schema table that I can use?