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: http://dev.mysql.com/doc/refman/5.6/en/show-create-trigger.html

