How to List Tables in MySQL

Last updated July 24, 2026 · By the SaturnSQL team

SHOW TABLES lists tables in the current database; SHOW TABLES LIKE filters by pattern. Query information_schema.tables when you need sizes, row estimates, or cross-database results.

SHOW TABLES;
SHOW TABLES LIKE 'order%';

SELECT table_name,
       table_rows,
       ROUND((data_length + index_length) / 1024 / 1024) AS size_mb
FROM information_schema.tables
WHERE table_schema = 'shop'
ORDER BY size_mb DESC;