This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new e70de4fbf2a fix: correct triggers information schema documentation
(#3193)
e70de4fbf2a is described below
commit e70de4fbf2aafe3cff34dae49db09846328a2b23
Author: Subham <[email protected]>
AuthorDate: Tue Feb 10 23:26:40 2026 +0530
fix: correct triggers information schema documentation (#3193)
Fixes #3164
### Overview
Corrected the documentation for `information_schema.triggers`.
Previously, the documentation incorrectly displayed the schema for the
`tables` table. This PR updates the `triggers` documentation to reflect
the correct MySQL-compatible schema (showing it as supported but always
empty in Doris).
### Versions
- [x] dev
- [ ] 4.x
- [x] 3.x
- [x] 2.1
### Languages
- [x] Chinese
- [x] English
### Docs Checklist
- [x] Checked by AI
- [ ] Test Cases Built
---
.../system-tables/information_schema/triggers.md | 52 +++++++++---------
.../system-tables/information_schema/triggers.md | 61 +++++++++++-----------
.../system-tables/information_schema/triggers.md | 61 +++++++++++-----------
.../system-tables/information_schema/triggers.md | 61 +++++++++++-----------
.../system-tables/information_schema/triggers.md | 52 +++++++++---------
.../system-tables/information_schema/triggers.md | 52 +++++++++---------
6 files changed, 168 insertions(+), 171 deletions(-)
diff --git a/docs/admin-manual/system-tables/information_schema/triggers.md
b/docs/admin-manual/system-tables/information_schema/triggers.md
index f8b48ea3f27..507e97e0a31 100644
--- a/docs/admin-manual/system-tables/information_schema/triggers.md
+++ b/docs/admin-manual/system-tables/information_schema/triggers.md
@@ -8,36 +8,36 @@
## Overview
-Stores all table information.
+The `triggers` table provides information about triggers.
+Currently, Apache Doris supports this table for MySQL compatibility, but does
not support user-defined triggers. This table is always empty.
## Database
-
`information_schema`
-
## Table Information
-| Column Name | Type | Description
|
-| --------------- | ------------- |
------------------------------------------------------------ |
-| TABLE_CATALOG | varchar(512) | The Catalog to which the table belongs
|
-| TABLE_SCHEMA | varchar(64) | The Database to which the table belongs
|
-| TABLE_NAME | varchar(64) | The name of the table
|
-| TABLE_TYPE | varchar(64) | The type of the table, including: SYSTEM
VIEW, VIEW, BASE TABLE |
-| ENGINE | varchar(64) | The storage engine type of the table
|
-| VERSION | bigint | Invalid value
|
-| ROW_FORMAT | varchar(10) | Invalid value
|
-| TABLE_ROWS | bigint | Estimated number of rows in the table
|
-| AVG_ROW_LENGTH | bigint | Average row size of the table
|
-| DATA_LENGTH | bigint | Estimated size of the table
|
-| MAX_DATA_LENGTH | bigint | Invalid value
|
-| INDEX_LENGTH | bigint | Invalid value
|
-| DATA_FREE | bigint | Invalid value
|
-| AUTO_INCREMENT | bigint | Invalid value
|
-| CREATE_TIME | datetime | The time when the table was created
|
-| UPDATE_TIME | datetime | The time when the table data was last
updated |
-| CHECK_TIME | datetime | Invalid value
|
-| TABLE_COLLATION | varchar(32) | Fixed value: utf-8
|
-| CHECKSUM | bigint | Invalid value
|
-| CREATE_OPTIONS | varchar(255) | Invalid value
|
-| TABLE_COMMENT | varchar(2048) | Comments on the table
|
\ No newline at end of file
+| Column Name | Type | Description |
+|---|---|---|
+| TRIGGER_CATALOG | varchar(512) | The name of the catalog to which the
trigger belongs. Always 'def'. |
+| TRIGGER_SCHEMA | varchar(64) | The name of the schema (database) to which
the trigger belongs. |
+| TRIGGER_NAME | varchar(64) | The name of the trigger. |
+| EVENT_MANIPULATION | varchar(6) | The trigger event (INSERT, UPDATE,
DELETE). |
+| EVENT_OBJECT_CATALOG | varchar(512) | The catalog name of the table with
which the trigger is associated. Always 'def'. |
+| EVENT_OBJECT_SCHEMA | varchar(64) | The schema (database) name of the table
with which the trigger is associated. |
+| EVENT_OBJECT_TABLE | varchar(64) | The name of the table with which the
trigger is associated. |
+| ACTION_ORDER | bigint | The ordinal definition order of the trigger. |
+| ACTION_CONDITION | varchar(512) | null |
+| ACTION_STATEMENT | varchar(512) | The trigger body. |
+| ACTION_ORIENTATION | varchar(9) | Always 'ROW'. |
+| ACTION_TIMING | varchar(6) | Trigger timing (BEFORE, AFTER). |
+| ACTION_REFERENCE_OLD_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_NEW_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_OLD_ROW | varchar(3) | Always 'OLD'. |
+| ACTION_REFERENCE_NEW_ROW | varchar(3) | Always 'NEW'. |
+| CREATED | datetime | The time when the trigger was created. |
+| SQL_MODE | varchar(8192) | The SQL mode in effect when the trigger was
created. |
+| DEFINER | varchar(77) | The account that created the trigger. |
+| CHARACTER_SET_CLIENT | varchar(32) | The session value of the
character_set_client system variable when the trigger was created. |
+| COLLATION_CONNECTION | varchar(32) | The session value of the
collation_connection system variable when the trigger was created. |
+| DATABASE_COLLATION | varchar(32) | The collation of the database with which
the trigger is associated. |
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/triggers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/triggers.md
index 5b7d43a1cd1..f3f95ba7c18 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/triggers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/triggers.md
@@ -6,39 +6,38 @@
}
---
-## 概述
+## Overview
-此表仅用于兼容 MySQL 行为。永远为空。
-
-## 所属数据库
+`triggers` 表提供了关于触发器的信息。
+目前，Apache Doris 支持此表是为了兼容 MySQL，但不支持用户自定义触发器。此表始终为空。
+## Database
`information_schema`
-
-## 表信息
-
-| 列名 | 类型 | 说明 |
-| :------------------------- | :------------ | :--- |
-| TRIGGER_CATALOG | varchar(512) | |
-| TRIGGER_SCHEMA | varchar(64) | |
-| TRIGGER_NAME | varchar(64) | |
-| EVENT_MANIPULATION | varchar(6) | |
-| EVENT_OBJECT_CATALOG | varchar(512) | |
-| EVENT_OBJECT_SCHEMA | varchar(64) | |
-| EVENT_OBJECT_TABLE | varchar(64) | |
-| ACTION_ORDER | varchar(4) | |
-| ACTION_CONDITION | varchar(512) | |
-| ACTION_STATEMENT | varchar(512) | |
-| ACTION_ORIENTATION | varchar(9) | |
-| ACTION_TIMING | varchar(6) | |
-| ACTION_REFERENCE_OLD_TABLE | varchar(64) | |
-| ACTION_REFERENCE_NEW_TABLE | varchar(64) | |
-| ACTION_REFERENCE_OLD_ROW | varchar(3) | |
-| ACTION_REFERENCE_NEW_ROW | varchar(3) | |
-| CREATED | datetime | |
-| SQL_MODE | varchar(8192) | |
-| DEFINER | varchar(77) | |
-| CHARACTER_SET_CLIENT | varchar(32) | |
-| COLLATION_CONNECTION | varchar(32) | |
-| DATABASE_COLLATION | varchar(32) | |
\ No newline at end of file
+## Table Information
+
+| Column Name | Type | Description |
+|---|---|---|
+| TRIGGER_CATALOG | varchar(512) | 触发器所属的目录名称。始终为 'def'。 |
+| TRIGGER_SCHEMA | varchar(64) | 触发器所属的模式（数据库）名称。 |
+| TRIGGER_NAME | varchar(64) | 触发器名称。 |
+| EVENT_MANIPULATION | varchar(6) | 触发器事件 (INSERT, UPDATE, DELETE)。 |
+| EVENT_OBJECT_CATALOG | varchar(512) | 与触发器关联的表的目录名称。始终为 'def'。 |
+| EVENT_OBJECT_SCHEMA | varchar(64) | 与触发器关联的表的模式（数据库）名称。 |
+| EVENT_OBJECT_TABLE | varchar(64) | 与触发器关联的表的名称。 |
+| ACTION_ORDER | bigint | 触发器的序号定义顺序。 |
+| ACTION_CONDITION | varchar(512) | null |
+| ACTION_STATEMENT | varchar(512) | 触发器主体。 |
+| ACTION_ORIENTATION | varchar(9) | 始终为 'ROW'。 |
+| ACTION_TIMING | varchar(6) | 触发器时机 (BEFORE, AFTER)。 |
+| ACTION_REFERENCE_OLD_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_NEW_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_OLD_ROW | varchar(3) | 始终为 'OLD'。 |
+| ACTION_REFERENCE_NEW_ROW | varchar(3) | 始终为 'NEW'。 |
+| CREATED | datetime | 触发器创建时间。 |
+| SQL_MODE | varchar(8192) | 触发器创建时生效的 SQL 模式。 |
+| DEFINER | varchar(77) | 创建触发器的账户。 |
+| CHARACTER_SET_CLIENT | varchar(32) | 触发器创建时 character_set_client 系统变量的会话值。 |
+| COLLATION_CONNECTION | varchar(32) | 触发器创建时 collation_connection 系统变量的会话值。 |
+| DATABASE_COLLATION | varchar(32) | 与触发器关联的数据库的排序规则。 |
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
index 5b7d43a1cd1..f3f95ba7c18 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
@@ -6,39 +6,38 @@
}
---
-## 概述
+## Overview
-此表仅用于兼容 MySQL 行为。永远为空。
-
-## 所属数据库
+`triggers` 表提供了关于触发器的信息。
+目前，Apache Doris 支持此表是为了兼容 MySQL，但不支持用户自定义触发器。此表始终为空。
+## Database
`information_schema`
-
-## 表信息
-
-| 列名 | 类型 | 说明 |
-| :------------------------- | :------------ | :--- |
-| TRIGGER_CATALOG | varchar(512) | |
-| TRIGGER_SCHEMA | varchar(64) | |
-| TRIGGER_NAME | varchar(64) | |
-| EVENT_MANIPULATION | varchar(6) | |
-| EVENT_OBJECT_CATALOG | varchar(512) | |
-| EVENT_OBJECT_SCHEMA | varchar(64) | |
-| EVENT_OBJECT_TABLE | varchar(64) | |
-| ACTION_ORDER | varchar(4) | |
-| ACTION_CONDITION | varchar(512) | |
-| ACTION_STATEMENT | varchar(512) | |
-| ACTION_ORIENTATION | varchar(9) | |
-| ACTION_TIMING | varchar(6) | |
-| ACTION_REFERENCE_OLD_TABLE | varchar(64) | |
-| ACTION_REFERENCE_NEW_TABLE | varchar(64) | |
-| ACTION_REFERENCE_OLD_ROW | varchar(3) | |
-| ACTION_REFERENCE_NEW_ROW | varchar(3) | |
-| CREATED | datetime | |
-| SQL_MODE | varchar(8192) | |
-| DEFINER | varchar(77) | |
-| CHARACTER_SET_CLIENT | varchar(32) | |
-| COLLATION_CONNECTION | varchar(32) | |
-| DATABASE_COLLATION | varchar(32) | |
\ No newline at end of file
+## Table Information
+
+| Column Name | Type | Description |
+|---|---|---|
+| TRIGGER_CATALOG | varchar(512) | 触发器所属的目录名称。始终为 'def'。 |
+| TRIGGER_SCHEMA | varchar(64) | 触发器所属的模式（数据库）名称。 |
+| TRIGGER_NAME | varchar(64) | 触发器名称。 |
+| EVENT_MANIPULATION | varchar(6) | 触发器事件 (INSERT, UPDATE, DELETE)。 |
+| EVENT_OBJECT_CATALOG | varchar(512) | 与触发器关联的表的目录名称。始终为 'def'。 |
+| EVENT_OBJECT_SCHEMA | varchar(64) | 与触发器关联的表的模式（数据库）名称。 |
+| EVENT_OBJECT_TABLE | varchar(64) | 与触发器关联的表的名称。 |
+| ACTION_ORDER | bigint | 触发器的序号定义顺序。 |
+| ACTION_CONDITION | varchar(512) | null |
+| ACTION_STATEMENT | varchar(512) | 触发器主体。 |
+| ACTION_ORIENTATION | varchar(9) | 始终为 'ROW'。 |
+| ACTION_TIMING | varchar(6) | 触发器时机 (BEFORE, AFTER)。 |
+| ACTION_REFERENCE_OLD_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_NEW_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_OLD_ROW | varchar(3) | 始终为 'OLD'。 |
+| ACTION_REFERENCE_NEW_ROW | varchar(3) | 始终为 'NEW'。 |
+| CREATED | datetime | 触发器创建时间。 |
+| SQL_MODE | varchar(8192) | 触发器创建时生效的 SQL 模式。 |
+| DEFINER | varchar(77) | 创建触发器的账户。 |
+| CHARACTER_SET_CLIENT | varchar(32) | 触发器创建时 character_set_client 系统变量的会话值。 |
+| COLLATION_CONNECTION | varchar(32) | 触发器创建时 collation_connection 系统变量的会话值。 |
+| DATABASE_COLLATION | varchar(32) | 与触发器关联的数据库的排序规则。 |
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/admin-manual/system-tables/information_schema/triggers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/admin-manual/system-tables/information_schema/triggers.md
index 5b7d43a1cd1..f3f95ba7c18 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/admin-manual/system-tables/information_schema/triggers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/admin-manual/system-tables/information_schema/triggers.md
@@ -6,39 +6,38 @@
}
---
-## 概述
+## Overview
-此表仅用于兼容 MySQL 行为。永远为空。
-
-## 所属数据库
+`triggers` 表提供了关于触发器的信息。
+目前，Apache Doris 支持此表是为了兼容 MySQL，但不支持用户自定义触发器。此表始终为空。
+## Database
`information_schema`
-
-## 表信息
-
-| 列名 | 类型 | 说明 |
-| :------------------------- | :------------ | :--- |
-| TRIGGER_CATALOG | varchar(512) | |
-| TRIGGER_SCHEMA | varchar(64) | |
-| TRIGGER_NAME | varchar(64) | |
-| EVENT_MANIPULATION | varchar(6) | |
-| EVENT_OBJECT_CATALOG | varchar(512) | |
-| EVENT_OBJECT_SCHEMA | varchar(64) | |
-| EVENT_OBJECT_TABLE | varchar(64) | |
-| ACTION_ORDER | varchar(4) | |
-| ACTION_CONDITION | varchar(512) | |
-| ACTION_STATEMENT | varchar(512) | |
-| ACTION_ORIENTATION | varchar(9) | |
-| ACTION_TIMING | varchar(6) | |
-| ACTION_REFERENCE_OLD_TABLE | varchar(64) | |
-| ACTION_REFERENCE_NEW_TABLE | varchar(64) | |
-| ACTION_REFERENCE_OLD_ROW | varchar(3) | |
-| ACTION_REFERENCE_NEW_ROW | varchar(3) | |
-| CREATED | datetime | |
-| SQL_MODE | varchar(8192) | |
-| DEFINER | varchar(77) | |
-| CHARACTER_SET_CLIENT | varchar(32) | |
-| COLLATION_CONNECTION | varchar(32) | |
-| DATABASE_COLLATION | varchar(32) | |
\ No newline at end of file
+## Table Information
+
+| Column Name | Type | Description |
+|---|---|---|
+| TRIGGER_CATALOG | varchar(512) | 触发器所属的目录名称。始终为 'def'。 |
+| TRIGGER_SCHEMA | varchar(64) | 触发器所属的模式（数据库）名称。 |
+| TRIGGER_NAME | varchar(64) | 触发器名称。 |
+| EVENT_MANIPULATION | varchar(6) | 触发器事件 (INSERT, UPDATE, DELETE)。 |
+| EVENT_OBJECT_CATALOG | varchar(512) | 与触发器关联的表的目录名称。始终为 'def'。 |
+| EVENT_OBJECT_SCHEMA | varchar(64) | 与触发器关联的表的模式（数据库）名称。 |
+| EVENT_OBJECT_TABLE | varchar(64) | 与触发器关联的表的名称。 |
+| ACTION_ORDER | bigint | 触发器的序号定义顺序。 |
+| ACTION_CONDITION | varchar(512) | null |
+| ACTION_STATEMENT | varchar(512) | 触发器主体。 |
+| ACTION_ORIENTATION | varchar(9) | 始终为 'ROW'。 |
+| ACTION_TIMING | varchar(6) | 触发器时机 (BEFORE, AFTER)。 |
+| ACTION_REFERENCE_OLD_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_NEW_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_OLD_ROW | varchar(3) | 始终为 'OLD'。 |
+| ACTION_REFERENCE_NEW_ROW | varchar(3) | 始终为 'NEW'。 |
+| CREATED | datetime | 触发器创建时间。 |
+| SQL_MODE | varchar(8192) | 触发器创建时生效的 SQL 模式。 |
+| DEFINER | varchar(77) | 创建触发器的账户。 |
+| CHARACTER_SET_CLIENT | varchar(32) | 触发器创建时 character_set_client 系统变量的会话值。 |
+| COLLATION_CONNECTION | varchar(32) | 触发器创建时 collation_connection 系统变量的会话值。 |
+| DATABASE_COLLATION | varchar(32) | 与触发器关联的数据库的排序规则。 |
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
b/versioned_docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
index f8b48ea3f27..507e97e0a31 100644
---
a/versioned_docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
+++
b/versioned_docs/version-2.1/admin-manual/system-tables/information_schema/triggers.md
@@ -8,36 +8,36 @@
## Overview
-Stores all table information.
+The `triggers` table provides information about triggers.
+Currently, Apache Doris supports this table for MySQL compatibility, but does
not support user-defined triggers. This table is always empty.
## Database
-
`information_schema`
-
## Table Information
-| Column Name | Type | Description
|
-| --------------- | ------------- |
------------------------------------------------------------ |
-| TABLE_CATALOG | varchar(512) | The Catalog to which the table belongs
|
-| TABLE_SCHEMA | varchar(64) | The Database to which the table belongs
|
-| TABLE_NAME | varchar(64) | The name of the table
|
-| TABLE_TYPE | varchar(64) | The type of the table, including: SYSTEM
VIEW, VIEW, BASE TABLE |
-| ENGINE | varchar(64) | The storage engine type of the table
|
-| VERSION | bigint | Invalid value
|
-| ROW_FORMAT | varchar(10) | Invalid value
|
-| TABLE_ROWS | bigint | Estimated number of rows in the table
|
-| AVG_ROW_LENGTH | bigint | Average row size of the table
|
-| DATA_LENGTH | bigint | Estimated size of the table
|
-| MAX_DATA_LENGTH | bigint | Invalid value
|
-| INDEX_LENGTH | bigint | Invalid value
|
-| DATA_FREE | bigint | Invalid value
|
-| AUTO_INCREMENT | bigint | Invalid value
|
-| CREATE_TIME | datetime | The time when the table was created
|
-| UPDATE_TIME | datetime | The time when the table data was last
updated |
-| CHECK_TIME | datetime | Invalid value
|
-| TABLE_COLLATION | varchar(32) | Fixed value: utf-8
|
-| CHECKSUM | bigint | Invalid value
|
-| CREATE_OPTIONS | varchar(255) | Invalid value
|
-| TABLE_COMMENT | varchar(2048) | Comments on the table
|
\ No newline at end of file
+| Column Name | Type | Description |
+|---|---|---|
+| TRIGGER_CATALOG | varchar(512) | The name of the catalog to which the
trigger belongs. Always 'def'. |
+| TRIGGER_SCHEMA | varchar(64) | The name of the schema (database) to which
the trigger belongs. |
+| TRIGGER_NAME | varchar(64) | The name of the trigger. |
+| EVENT_MANIPULATION | varchar(6) | The trigger event (INSERT, UPDATE,
DELETE). |
+| EVENT_OBJECT_CATALOG | varchar(512) | The catalog name of the table with
which the trigger is associated. Always 'def'. |
+| EVENT_OBJECT_SCHEMA | varchar(64) | The schema (database) name of the table
with which the trigger is associated. |
+| EVENT_OBJECT_TABLE | varchar(64) | The name of the table with which the
trigger is associated. |
+| ACTION_ORDER | bigint | The ordinal definition order of the trigger. |
+| ACTION_CONDITION | varchar(512) | null |
+| ACTION_STATEMENT | varchar(512) | The trigger body. |
+| ACTION_ORIENTATION | varchar(9) | Always 'ROW'. |
+| ACTION_TIMING | varchar(6) | Trigger timing (BEFORE, AFTER). |
+| ACTION_REFERENCE_OLD_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_NEW_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_OLD_ROW | varchar(3) | Always 'OLD'. |
+| ACTION_REFERENCE_NEW_ROW | varchar(3) | Always 'NEW'. |
+| CREATED | datetime | The time when the trigger was created. |
+| SQL_MODE | varchar(8192) | The SQL mode in effect when the trigger was
created. |
+| DEFINER | varchar(77) | The account that created the trigger. |
+| CHARACTER_SET_CLIENT | varchar(32) | The session value of the
character_set_client system variable when the trigger was created. |
+| COLLATION_CONNECTION | varchar(32) | The session value of the
collation_connection system variable when the trigger was created. |
+| DATABASE_COLLATION | varchar(32) | The collation of the database with which
the trigger is associated. |
\ No newline at end of file
diff --git
a/versioned_docs/version-3.x/admin-manual/system-tables/information_schema/triggers.md
b/versioned_docs/version-3.x/admin-manual/system-tables/information_schema/triggers.md
index f8b48ea3f27..507e97e0a31 100644
---
a/versioned_docs/version-3.x/admin-manual/system-tables/information_schema/triggers.md
+++
b/versioned_docs/version-3.x/admin-manual/system-tables/information_schema/triggers.md
@@ -8,36 +8,36 @@
## Overview
-Stores all table information.
+The `triggers` table provides information about triggers.
+Currently, Apache Doris supports this table for MySQL compatibility, but does
not support user-defined triggers. This table is always empty.
## Database
-
`information_schema`
-
## Table Information
-| Column Name | Type | Description
|
-| --------------- | ------------- |
------------------------------------------------------------ |
-| TABLE_CATALOG | varchar(512) | The Catalog to which the table belongs
|
-| TABLE_SCHEMA | varchar(64) | The Database to which the table belongs
|
-| TABLE_NAME | varchar(64) | The name of the table
|
-| TABLE_TYPE | varchar(64) | The type of the table, including: SYSTEM
VIEW, VIEW, BASE TABLE |
-| ENGINE | varchar(64) | The storage engine type of the table
|
-| VERSION | bigint | Invalid value
|
-| ROW_FORMAT | varchar(10) | Invalid value
|
-| TABLE_ROWS | bigint | Estimated number of rows in the table
|
-| AVG_ROW_LENGTH | bigint | Average row size of the table
|
-| DATA_LENGTH | bigint | Estimated size of the table
|
-| MAX_DATA_LENGTH | bigint | Invalid value
|
-| INDEX_LENGTH | bigint | Invalid value
|
-| DATA_FREE | bigint | Invalid value
|
-| AUTO_INCREMENT | bigint | Invalid value
|
-| CREATE_TIME | datetime | The time when the table was created
|
-| UPDATE_TIME | datetime | The time when the table data was last
updated |
-| CHECK_TIME | datetime | Invalid value
|
-| TABLE_COLLATION | varchar(32) | Fixed value: utf-8
|
-| CHECKSUM | bigint | Invalid value
|
-| CREATE_OPTIONS | varchar(255) | Invalid value
|
-| TABLE_COMMENT | varchar(2048) | Comments on the table
|
\ No newline at end of file
+| Column Name | Type | Description |
+|---|---|---|
+| TRIGGER_CATALOG | varchar(512) | The name of the catalog to which the
trigger belongs. Always 'def'. |
+| TRIGGER_SCHEMA | varchar(64) | The name of the schema (database) to which
the trigger belongs. |
+| TRIGGER_NAME | varchar(64) | The name of the trigger. |
+| EVENT_MANIPULATION | varchar(6) | The trigger event (INSERT, UPDATE,
DELETE). |
+| EVENT_OBJECT_CATALOG | varchar(512) | The catalog name of the table with
which the trigger is associated. Always 'def'. |
+| EVENT_OBJECT_SCHEMA | varchar(64) | The schema (database) name of the table
with which the trigger is associated. |
+| EVENT_OBJECT_TABLE | varchar(64) | The name of the table with which the
trigger is associated. |
+| ACTION_ORDER | bigint | The ordinal definition order of the trigger. |
+| ACTION_CONDITION | varchar(512) | null |
+| ACTION_STATEMENT | varchar(512) | The trigger body. |
+| ACTION_ORIENTATION | varchar(9) | Always 'ROW'. |
+| ACTION_TIMING | varchar(6) | Trigger timing (BEFORE, AFTER). |
+| ACTION_REFERENCE_OLD_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_NEW_TABLE | varchar(64) | null |
+| ACTION_REFERENCE_OLD_ROW | varchar(3) | Always 'OLD'. |
+| ACTION_REFERENCE_NEW_ROW | varchar(3) | Always 'NEW'. |
+| CREATED | datetime | The time when the trigger was created. |
+| SQL_MODE | varchar(8192) | The SQL mode in effect when the trigger was
created. |
+| DEFINER | varchar(77) | The account that created the trigger. |
+| CHARACTER_SET_CLIENT | varchar(32) | The session value of the
character_set_client system variable when the trigger was created. |
+| COLLATION_CONNECTION | varchar(32) | The session value of the
collation_connection system variable when the trigger was created. |
+| DATABASE_COLLATION | varchar(32) | The collation of the database with which
the trigger is associated. |
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
