Displays the attributes for a specified trigger.
Privileges
You must either own the specified trigger or table or have at least one privilege on its containing database or, for a trigger, its subject table.
Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against the specified trigger.