mysql.information_schema.ADDITIONAL_COLUMN_ATTRIBUTES.sql Maven / Gradle / Ivy
SELECT
TABLE_SCHEMA AS TABLE_CATALOG,
NULL AS TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME,
COLUMN_TYPE, -- required to find enum columns
CHARACTER_SET_NAME,
COLLATION_NAME,
COLUMN_COMMENT,
GENERATION_EXPRESSION,
EXTRA
FROM
INFORMATION_SCHEMA.COLUMNS