information_schema.triggers.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
triggers |
||||||||
action_condition |
BINARY NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
action_order |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| unsupported | CARDINAL_NUMBER NULL:
CARDINAL_NUMBER:
| unsupported | unsupported | ||
action_orientation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
action_reference_new_row |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
action_reference_new_table |
BINARY NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| unsupported | unsupported | ||
action_reference_old_row |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
action_reference_old_table |
BINARY NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| unsupported | unsupported | ||
action_statement |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| unsupported | unsupported | ||
action_timing |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
condition_reference_new_row |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_reference_new_table |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_reference_old_row |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_reference_old_table |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
condition_timing |
unsupported | unsupported | unsupported | CHARACTER_DATA:
| unsupported | unsupported | ||
created |
TIMESTAMP NOT NULL:
8
DATETIME NULL:
5.7
| NULL:
| unsupported | TIME_STAMP:
TIME_STAMP NULL:
| unsupported | unsupported | ||
database_collation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
definer |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
event_manipulation |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
event_object_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
event_object_table |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
sql_mode |
SET NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
trigger_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
trigger_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||