-- AccessDB Rescue (accessdbrescue.eu): structure of this MySQL / MariaDB database. Read-only, reads no data. -- Returns one row per table, view, procedure, function, trigger and foreign key, with row counts and code size. -- Run it with the application's database selected (USE yourdatabase;). Row counts are MySQL's estimates. -- Save the result as CSV (MySQL Workbench: Export recordset to an external file) and add that file to the scan. SELECT 'database' AS object_type, '' AS schema_name, DATABASE() AS object_name, NULL AS row_count, NULL AS column_count, NULL AS has_pk, CONCAT('MySQL ', VERSION()) AS ref_name, NULL AS code_lines UNION ALL SELECT 'table', t.TABLE_SCHEMA, t.TABLE_NAME, t.TABLE_ROWS, (SELECT COUNT(*) FROM information_schema.COLUMNS c WHERE c.TABLE_SCHEMA = t.TABLE_SCHEMA AND c.TABLE_NAME = t.TABLE_NAME), (SELECT IF(COUNT(*) > 0, 1, 0) FROM information_schema.TABLE_CONSTRAINTS k WHERE k.TABLE_SCHEMA = t.TABLE_SCHEMA AND k.TABLE_NAME = t.TABLE_NAME AND k.CONSTRAINT_TYPE = 'PRIMARY KEY'), NULL, NULL FROM information_schema.TABLES t WHERE t.TABLE_SCHEMA = DATABASE() AND t.TABLE_TYPE = 'BASE TABLE' UNION ALL SELECT 'view', v.TABLE_SCHEMA, v.TABLE_NAME, NULL, NULL, NULL, NULL, LENGTH(v.VIEW_DEFINITION) - LENGTH(REPLACE(v.VIEW_DEFINITION, '\n', '')) + 1 FROM information_schema.VIEWS v WHERE v.TABLE_SCHEMA = DATABASE() UNION ALL SELECT LOWER(r.ROUTINE_TYPE), r.ROUTINE_SCHEMA, r.ROUTINE_NAME, NULL, NULL, NULL, NULL, LENGTH(r.ROUTINE_DEFINITION) - LENGTH(REPLACE(r.ROUTINE_DEFINITION, '\n', '')) + 1 FROM information_schema.ROUTINES r WHERE r.ROUTINE_SCHEMA = DATABASE() UNION ALL SELECT 'trigger', g.TRIGGER_SCHEMA, g.TRIGGER_NAME, NULL, NULL, NULL, g.EVENT_OBJECT_TABLE, NULL FROM information_schema.TRIGGERS g WHERE g.TRIGGER_SCHEMA = DATABASE() UNION ALL SELECT 'foreign_key', f.CONSTRAINT_SCHEMA, f.TABLE_NAME, NULL, NULL, NULL, f.REFERENCED_TABLE_NAME, NULL FROM information_schema.REFERENTIAL_CONSTRAINTS f WHERE f.CONSTRAINT_SCHEMA = DATABASE() ORDER BY 1, 2, 3;