Syntax
------

SHOW CREATE TRIGGER trigger_name

Description
-----------

This statement shows a CREATE TRIGGER statement that creates the given
trigger, as well as the SQL_MODE that was used when the trigger has been
created and the character set used by the connection.

The TRIGGER privilege is required on the table the trigger is defined for to
execute this statement.

SHOW CREATE TRIGGER quotes identifiers according to the value of the
sql_quote_show_create system variable. Prior to MariaDB 10.6.5, MariaDB
10.5.13 and MariaDB 10.4.22, the output of this statement was unreliably
affected by the sql_quote_show_create system variable.

Examples
--------

SHOW CREATE TRIGGER example\G
*************************** 1. row ***************************
       Trigger: example
       sql_mode:
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,STRICT_ALL_TABLES
,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO

ENGINE_SUBSTITUTION
SQL Original Statement: CREATE DEFINER=`root`@`localhost` TRIGGER example
BEFORE
 INSERT ON t FOR EACH ROW
BEGIN
    SET NEW.c = NEW.c * 2;
END
 character_set_client: cp850
 collation_connection: cp850_general_ci
 Database Collation: utf8_general_ci
 Created: 2016-09-29 13:53:34.35

The Created column was added in MariaDB 10.2.3 as part of introducing multiple
trigger events per action.

URL: https://mariadb.com/kb/en/show-create-trigger/