Syntax\n------\n\nSHOW TRIGGERS [FROM db_name]\n    [LIKE 'pattern' | WHERE expr]\n\nDescription\n-----------\n\nSHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement requires the TRIGGER privilege.\n\nSHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement requires the SUPER privilege.\n\nThe LIKE clause, if present on its own, indicates which table names to match and causes the statement to display triggers for those tables. The WHERE and LIKE clauses can be given to select rows using more general conditions, as discussed in Extended SHOW.\n\nSimilar information is stored in the information_schema.TRIGGERS table.\n\nIf there are multiple triggers for the same action, then the triggers are shown in action order.\n\nExamples\n--------\n\nSHOW triggers Like 'animals' \\G\n************************ 1. row ************************\n             Trigger: the_mooses_are_loose\n               Event: INSERT\n               Table: animals\n           Statement: BEGIN\n IF NEW.name = 'Moose' THEN\n  UPDATE animal_count SET animal_count.animals = animal_count.animals+100;\n ELSE \n  UPDATE animal_count SET animal_count.animals = animal_count.animals+1;\n END IF;\nEND\n              Timing: AFTER\n             Created: 2016-09-29 13:53:34.35\n            sql_mode: \n             Definer: root@localhost\ncharacter_set_client: utf8\ncollation_connection: utf8_general_ci\n  Database Collation: latin1_swedish_ci\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers