Information Schema TRIGGERS Table
The Information Schema
TRIGGERS table contains information about triggers.
It has the following columns:
|Database name in which the trigger occurs.|
|Name of the trigger.|
|The event that activates the trigger. One of |
|Database name on which the trigger acts.|
|Table name on which the trigger acts.|
|Indicates the order that the action will be performed in (of the list of a table's triggers with identical |
|Trigger body, UTF-8 encoded.|
|Whether the trigger acts |
|The account that created the trigger, in the form |
|The client character set when the trigger was created, from the session value of the |
|The client collation when the trigger was created, from the session value of the collation_connection system variable.|
|Collation of the associated database.|
Queries to the
TRIGGERS table will return information only for databases and tables for which you have the
TRIGGER privilege. Similar information is returned by the
SHOW TRIGGERS statement.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.