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

         ---               

SELECT * FROM `COLUMNS`

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

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `COLUMNS`

Felder der Tabelle `COLUMNS`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	TABLE_CATALOG	varchar	512	nein					utf8_general_ci
	2.	TABLE_SCHEMA	varchar	64	nein					utf8_general_ci
	3.	TABLE_NAME	varchar	64	nein					utf8_general_ci
	4.	COLUMN_NAME	varchar	64	nein					utf8_general_ci
	5.	ORDINAL_POSITION	bigint	21	nein		unsigned
	6.	COLUMN_DEFAULT	longtext		ja					utf8_general_ci
	7.	IS_NULLABLE	varchar	3	nein					utf8_general_ci
	8.	DATA_TYPE	varchar	64	nein					utf8_general_ci
	9.	CHARACTER_MAXIMUM_LENGTH	bigint	21	ja		unsigned
	10.	CHARACTER_OCTET_LENGTH	bigint	21	ja		unsigned
	11.	NUMERIC_PRECISION	bigint	21	ja		unsigned
	12.	NUMERIC_SCALE	bigint	21	ja		unsigned
	13.	DATETIME_PRECISION	bigint	21	ja		unsigned
	14.	CHARACTER_SET_NAME	varchar	32	ja					utf8_general_ci
	15.	COLLATION_NAME	varchar	32	ja					utf8_general_ci
	16.	COLUMN_TYPE	longtext		nein					utf8_general_ci
	17.	COLUMN_KEY	varchar	3	nein					utf8_general_ci
	18.	EXTRA	varchar	80	nein					utf8_general_ci
	19.	PRIVILEGES	varchar	80	nein					utf8_general_ci
	20.	COLUMN_COMMENT	varchar	1024	nein					utf8_general_ci
	21.	IS_GENERATED	varchar	6	nein					utf8_general_ci
	22.	GENERATION_EXPRESSION	longtext		ja					utf8_general_ci

Indizes der Tabelle `COLUMNS`