> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-triggers-table.md).

# Information Schema TRIGGERS Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `TRIGGERS` table contains information about [triggers](/docs/server/server-usage/triggers-events/triggers.md).

It has the following columns:

| Column                        | Description                                                                                                                                                                                                                                                                                                 |
| ----------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| TRIGGER\_CATALOG              | Always def.                                                                                                                                                                                                                                                                                                 |
| TRIGGER\_SCHEMA               | Database name in which the trigger occurs.                                                                                                                                                                                                                                                                  |
| TRIGGER\_NAME                 | Name of the trigger.                                                                                                                                                                                                                                                                                        |
| EVENT\_MANIPULATION           | The event that activates the trigger. Prior to MariaDB 12.0, one of `INSERT`, `UPDATE` or `DELETE`. From MariaDB 12.0, can contain multiple values, comma-separated.                                                                                                                                        |
| EVENT\_OBJECT\_CATALOG        | Always def.                                                                                                                                                                                                                                                                                                 |
| EVENT\_OBJECT\_SCHEMA         | Database name on which the trigger acts.                                                                                                                                                                                                                                                                    |
| EVENT\_OBJECT\_TABLE          | Table name on which the trigger acts.                                                                                                                                                                                                                                                                       |
| ACTION\_ORDER                 | Indicates the order that the action will be performed in (of the list of a table's triggers with identical `EVENT_MANIPULATION` and `ACTION_TIMING` values). See the [FOLLOWS/PRECEDES](/docs/server/server-usage/triggers-events/triggers/create-trigger.md#follows-precedes-other_trigger_name) clauses.  |
| ACTION\_CONDITION             | `NULL`                                                                                                                                                                                                                                                                                                      |
| ACTION\_STATEMENT             | Trigger body, UTF-8 encoded.                                                                                                                                                                                                                                                                                |
| ACTION\_ORIENTATION           | Always ROW.                                                                                                                                                                                                                                                                                                 |
| ACTION\_TIMING                | Whether the trigger acts `BEFORE` or `AFTER` the event that triggers it.                                                                                                                                                                                                                                    |
| ACTION\_REFERENCE\_OLD\_TABLE | Always `NULL`.                                                                                                                                                                                                                                                                                              |
| ACTION\_REFERENCE\_NEW\_TABLE | Always `NULL`.                                                                                                                                                                                                                                                                                              |
| ACTION\_REFERENCE\_OLD\_ROW   | Always `OLD`.                                                                                                                                                                                                                                                                                               |
| ACTION\_REFERENCE\_NEW\_ROW   | Always `NEW`.                                                                                                                                                                                                                                                                                               |
| CREATED                       | Always `NULL`.                                                                                                                                                                                                                                                                                              |
| SQL\_MODE                     | The [SQL\_MODE](/docs/server/server-management/variables-and-modes/sql_mode.md) when the trigger was created, and which it uses for execution.                                                                                                                                                              |
| DEFINER                       | The account that created the trigger, in the form user\_name\@host\_name                                                                                                                                                                                                                                    |
| CHARACTER\_SET\_CLIENT        | The client [character set](/docs/server/reference/data-types/string-data-types/character-sets.md) when the trigger was created, from the session value of the [character\_set\_client](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_set_client) system variable. |
| COLLATION\_CONNECTION         | The client [collation](/docs/server/reference/data-types/string-data-types/character-sets.md) when the trigger was created, from the session value of the [collation\_connection](/docs/server/server-management/variables-and-modes/server-system-variables.md#collation_connection) system variable.      |
| DATABASE\_COLLATION           | [Collation](/docs/server/reference/data-types/string-data-types/character-sets.md) of the associated database.                                                                                                                                                                                              |

Queries to the `TRIGGERS` table return information even if the user doesn't have `SELECT` [privileges](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#column-privileges) on the columns. The columns `ACTION_CONDITION`, `ACTION_STATEMENT` and `DEFINER` are `NULL` unless the user has the `TRIGGER` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#table-privileges). Similar information is returned by the [SHOW TRIGGERS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md) statement.

## See also

* [Trigger Overview](/docs/server/server-usage/triggers-events/triggers/trigger-overview.md)
* [CREATE TRIGGER](/docs/server/server-usage/triggers-events/triggers/create-trigger.md)
* [DROP TRIGGER](/docs/server/reference/sql-statements/data-definition/drop/drop-trigger.md)
* [SHOW TRIGGERS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md)
* [SHOW CREATE TRIGGER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-trigger.md)
* [Trigger Limitations](/docs/server/server-usage/triggers-events/triggers/trigger-limitations.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}