To accomplish this task its simple with the below script :
sp_msforeachdb ‘select “?” AS db, * from [?].sys.tables’
By executing the Above script you can get a list of all the tables in all the databases in separate window.
Any Comments regarding this post is welcome.
Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )