| How to count number of tables in sql server specific DataBase
Below is the syntax or command to count the tables in specific database
USE DataBase_NAME
SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table'
Or
SELECT * FROM SYS.objects WHERE TYPE = 'U'
| | |