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.