List All Databases, Objects, Tables by A Simple Single Line Query.

Try below query and see all databases and objects get listed in sql server.

[code:sql]sp_msforeachdb ‘select "?" AS db, * from [?].sys.tables’;[/code]