Query to get the total no of tables in a ms sql server database


In this programming tutorial you will learn the query to get the total no of tables in ms sql server database. Its quite easy. Lets have a look over the query mentioned below.

-- This query will give you the total no of user created tables
Select Count(*) As TableCount
From   Information_Schema.Tables
Where  Table_Type = 'BASE TABLE'
Table_Type='BASE TABLE' means the tables created by the users.

So that's it.
I love your feedback.

0 comments: