How to Get the Number of Tables from SQL Server Database ?

Below is a sample SQL query that demonstrates how to count the number of tables in a SQL Server database using information_schema.tables.

How to Get the Number of Tables from SQL Server Database ?

USE TrainingDB1
SELECT COUNT(*) as TableNos from information_schema.tables 
WHERE table_type = 'base table' 

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.