How to List Tables in ClickHouse

Last updated July 25, 2026 · By the SaturnSQL team

SHOW TABLES lists tables in the current database, with FROM and LIKE for filtering. Query system.tables when you need engines, row counts, or sizes across databases.

SHOW TABLES;
SHOW TABLES FROM analytics LIKE '%events%';

SELECT name, engine, total_rows,
       formatReadableSize(total_bytes) AS size
FROM system.tables
WHERE database = 'analytics'
ORDER BY total_bytes DESC;