Hi
The following script also can be used to findout, No of tables available in ALL the database(s) in active instance
Create Table #TableCount
(
DBName Varchar(100),
TableCount Int
)
Insert #TableCount
Exec Sp_MsforeachDB 'Use [?]; Select DB_Name(),Count(1) from sys.all_objects Where type=''U'' And is_ms_shipped =0 Having Count(1) >1'
Select * from #TableCount
Drop Table #TableCount