SELECT 
    TABLE_NAME AS 'Table',
    TABLE_ROWS AS 'Number of Rows'
FROM 
    information_schema.TABLES 
WHERE 
    TABLE_SCHEMA = DATABASE()
ORDER BY 
    TABLE_NAME;