How to List Tables in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

SHOW TABLES lists tables in the current schema with size and row counts. For queryable results you can filter and join, use information_schema.tables instead.

SHOW TABLES;
SHOW TABLES LIKE 'order%' IN SCHEMA analytics.public;

SELECT table_name, row_count, bytes
FROM analytics.information_schema.tables
WHERE table_schema = 'PUBLIC'
ORDER BY bytes DESC;