how Do I list all table names in SQL Server using T-SQL?

Question

SELECT name FROM sys.databases  -- this can list all database name in the server


user database
SELECT * FROM INFORMATION_SCHEMA.TABLES  
     -- these two line can list the table for one particular database 

But how can I output the results like below?

Database              Table
---------             -------------
db1                    t1
db1                    t2
db2                    t1
...                    ...

Answer 1

sp_msforeachdb 'select "?" AS db, * from [?].sys.tables'