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 ... ... ```

Accepted Answer

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

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

Solution

Problem