Headder AdSence

How to find the No. of tables list in SQL Server Database


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'