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'
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_2PJCU2ekblzCX1yEvfj98wgfW06ROAT1mh394-yOInUQ0Yi2aI5Z8ffbKoQACMgPrid20L-rYduMTKJNRIq_DHsFPJ3Z7LxmeLTshBXw4XnzUICo1zw0NLuSyt1RFLf03cC3Vwia49s/s640/1.jpg)
SELECT *FROMINFORMATION_SCHEMA.TABLESwhereTABLE_CATALOG='Thirmal'
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFqZOo5XjFfGQ4URVFlq7o1uN_i-UVX8WAkxRkJF0xfuFtM68dl4FW16azLOFDfhUrd_b2TgGPFnRT5-ZECl_3qlIdPZmfcYPjQRX2sCxcu0NxT8KKJ6SkcvEa3OdXP0fIs9q4xgNMlmI/s640/2.jpg)
2. Using sys.tables SELECT *FROM sys.tables
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZLjoILGdvBpsp_T5ttDe7WbjxdwngvEZvl-uRet92t00CtuTpCSTKSuMtRpVEntdFAw9-By7-Z-Tn-Hp-0DoyLtNclHtDV_-wVE_m0R5NvHYKYLF7cta_1fcGCzw2ZzVfx55NneWYTiU/s640/3.jpg)
3. Using sysobjects
SELECT *FROMsysobjects WHERE xtype = 'U'
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxsSVn-PNDvrK_7IzlupmQXz6GGcd09DbiRjJ8chgL4xLyAZ4zaTvzie9_t4gr6DssdgSq47gyScOITIchZ1j0_pfRbLppWPgTwkTuKp9TFa3YcAkc_b5Ar5O9T3Jlo_avkYya0vXcAV8/s640/4.jpg)