[Tools]  Datenbank: `information_schema`  Tabelle: `TRIGGERS`

         ---               

SELECT * FROM `TRIGGERS`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `TRIGGERS`

Felder der Tabelle `TRIGGERS`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	TRIGGER_CATALOG	varchar	512	nein					utf8_general_ci
	2.	TRIGGER_SCHEMA	varchar	64	nein					utf8_general_ci
	3.	TRIGGER_NAME	varchar	64	nein					utf8_general_ci
	4.	EVENT_MANIPULATION	varchar	6	nein					utf8_general_ci
	5.	EVENT_OBJECT_CATALOG	varchar	512	nein					utf8_general_ci
	6.	EVENT_OBJECT_SCHEMA	varchar	64	nein					utf8_general_ci
	7.	EVENT_OBJECT_TABLE	varchar	64	nein					utf8_general_ci
	8.	ACTION_ORDER	bigint	4	nein
	9.	ACTION_CONDITION	longtext		ja					utf8_general_ci
	10.	ACTION_STATEMENT	longtext		nein					utf8_general_ci
	11.	ACTION_ORIENTATION	varchar	9	nein					utf8_general_ci
	12.	ACTION_TIMING	varchar	6	nein					utf8_general_ci
	13.	ACTION_REFERENCE_OLD_TABLE	varchar	64	ja					utf8_general_ci
	14.	ACTION_REFERENCE_NEW_TABLE	varchar	64	ja					utf8_general_ci
	15.	ACTION_REFERENCE_OLD_ROW	varchar	3	nein					utf8_general_ci
	16.	ACTION_REFERENCE_NEW_ROW	varchar	3	nein					utf8_general_ci
	17.	CREATED	datetime	2	ja
	18.	SQL_MODE	varchar	8192	nein					utf8_general_ci
	19.	DEFINER	varchar	189	nein					utf8_general_ci
	20.	CHARACTER_SET_CLIENT	varchar	32	nein					utf8_general_ci
	21.	COLLATION_CONNECTION	varchar	32	nein					utf8_general_ci
	22.	DATABASE_COLLATION	varchar	32	nein					utf8_general_ci

Indizes der Tabelle `TRIGGERS`