Try

-- SQL 2005 and later
SELECT COUNT(*) FROM sys.tables

-- SQL 2000 and later
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_TYPE = 'BASE TABLE'

>
>Is there SQL Syntax or Store Procedure to get the total number of tables in a database?
>
>