SHOW CREATE TRIGGER trigger_name
The SHOW CREATE TRIGGER statement returns the CREATE TRIGGER statement used to create the specified trigger. To use this statement, you must have the TRIGGER privilege on the table associated with the trigger.
The following table lists the SHOW CREATE TRIGGER output columns.
| Column | Description |
|---|---|
Trigger |
The name of the trigger. |
sql_mode |
The SQL mode in effect when the trigger is executed. |
SQL Original Statement |
The CREATE TRIGGER statement that defines the trigger. |
character_set_client |
The session value of character_set_client when the trigger was created. |
collation_connection |
The session value of collation_connection when the trigger was created. |
Database Collation |
The collation of the database with which the trigger is associated. |
Created |
The date and time when the trigger was created, represented as a TIMESTAMP(2) value with fractional seconds. |
Trigger details are also available through the INFORMATION_SCHEMA.TRIGGERS view.
For more information, see the MySQL documentation: SHOW CREATE TRIGGER Statement.