Find the number of tables in Azure SQL Database

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


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


  • tables - number of tables in a database


The query returns just one row.

Sample results

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

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