MariaDB y MySQL – Cómo listar columnas, tablas y tipos de una base de datos

USE information_schema;

SELECT TABLE_NAME, GROUP_CONCAT(COLUMN_NAME), GROUP_CONCAT(DATA_TYPE)
FROM `COLUMNS`
WHERE TABLE_SCHEMA = 'mydatabase'
GROUP BY TABLE_NAME

 12,527 total views,  3 views today