SELECT 
    TABLE_NAME AS tableName,
    ENGINE AS engine,
    TABLE_COLLATION AS tableCollation,
    TABLE_ROWS AS recordCount,
    DATA_LENGTH + INDEX_LENGTH AS tableSizeBytes
FROM 
    information_schema.TABLES
WHERE 
    TABLE_SCHEMA = DATABASE()
ORDER BY 
    tableSizeBytes DESC;