My account Book a demo
Azure SQL Database Data Dictionary Query Toolbox

Find the number of tables in Azure SQL Database

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

The query below returns the total number of tables in the current database.

Query

select count(*) as [tables]
   from sys.tables

Columns

  • tables - number of tables in a database

Rows

The query returns just one row.

Sample results

Those results show that there are 16 tables in the AdventureWorksLT database.