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'