Sql Programming Tutorials, Guides & Best Practices

To identify the largest table in terms of size within a specific database, use a similar query but without the grouping. Instead, order by size and limit the result to find the largest table:

SELECT table_name AS "Table",
       ROUND((data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY (data_length + index_length) DESC
LIMIT 1;