Syntax:
SHOW CREATE TRIGGER trigger_name

This statement shows the CREATE TRIGGER statement that creates the
named trigger. This statement requires the TRIGGER privilege for the
table associated with the trigger.

URL: https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html

