SET @table=(SELECT DATABASE()); select @table; SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = @table ORDER BY (data_length + index_length) DESC;