My account Book a demo
Snowflake Data Dictionary Query Toolbox

Find number of tables in Snowflake

Article for: SQL Server Azure SQL Database Oracle database Amazon Redshift IBM Db2 Teradata Vertica PostgreSQL MySQL MariaDB Microsoft Access

Query below returns total number of tables in current database.

Query

select count(*) as tables
from information_schema.tables 
where table_type = 'BASE TABLE';

Columns

  • tables - number of tables in a database

Rows

Query returns just one row.

Sample results

Those results show that there are 87 tables in SNOWFLAKE_SAMPLE_DATA database.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.