I know few way to find the no. of tables in SQL Server Database.
1. Using INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
SELECT *FROMINFORMATION_SCHEMA.TABLESwhereTABLE_CATALOG='Thirmal'
2. Using sys.tables SELECT *FROM sys.tables
3. Using sysobjects
SELECT *FROMsysobjects WHERE xtype = 'U'