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

         ---               

SELECT * FROM `ROUTINES`

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

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `ROUTINES`

Felder der Tabelle `ROUTINES`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	SPECIFIC_NAME	varchar	64	nein					utf8_general_ci
	2.	ROUTINE_CATALOG	varchar	512	nein					utf8_general_ci
	3.	ROUTINE_SCHEMA	varchar	64	nein					utf8_general_ci
	4.	ROUTINE_NAME	varchar	64	nein					utf8_general_ci
	5.	ROUTINE_TYPE	varchar	13	nein					utf8_general_ci
	6.	DATA_TYPE	varchar	64	nein					utf8_general_ci
	7.	CHARACTER_MAXIMUM_LENGTH	int	21	ja
	8.	CHARACTER_OCTET_LENGTH	int	21	ja
	9.	NUMERIC_PRECISION	int	21	ja
	10.	NUMERIC_SCALE	int	21	ja
	11.	DATETIME_PRECISION	bigint	21	ja		unsigned
	12.	CHARACTER_SET_NAME	varchar	64	ja					utf8_general_ci
	13.	COLLATION_NAME	varchar	64	ja					utf8_general_ci
	14.	DTD_IDENTIFIER	longtext		ja					utf8_general_ci
	15.	ROUTINE_BODY	varchar	8	nein					utf8_general_ci
	16.	ROUTINE_DEFINITION	longtext		ja					utf8_general_ci
	17.	EXTERNAL_NAME	varchar	64	ja					utf8_general_ci
	18.	EXTERNAL_LANGUAGE	varchar	64	ja					utf8_general_ci
	19.	PARAMETER_STYLE	varchar	8	nein					utf8_general_ci
	20.	IS_DETERMINISTIC	varchar	3	nein					utf8_general_ci
	21.	SQL_DATA_ACCESS	varchar	64	nein					utf8_general_ci
	22.	SQL_PATH	varchar	64	ja					utf8_general_ci
	23.	SECURITY_TYPE	varchar	7	nein					utf8_general_ci
	24.	CREATED	datetime		nein
	25.	LAST_ALTERED	datetime		nein
	26.	SQL_MODE	varchar	8192	nein					utf8_general_ci
	27.	ROUTINE_COMMENT	longtext		nein					utf8_general_ci
	28.	DEFINER	varchar	189	nein					utf8_general_ci
	29.	CHARACTER_SET_CLIENT	varchar	32	nein					utf8_general_ci
	30.	COLLATION_CONNECTION	varchar	32	nein					utf8_general_ci
	31.	DATABASE_COLLATION	varchar	32	nein					utf8_general_ci

Indizes der Tabelle `ROUTINES`