find Different Database tables and Database in One Query

Hello, all Sql Experts,

You May also use this query to find out different tables and Databases through one query.

For Example

For Finding Databases

Select * from sys.databases

For Finding Tables

use database

Select * from sys.tables

Create Table #AllTables

(

DBName		Varchar(100),

TableName	Varchar(128)

)



Insert #AllTables

Exec Sp_MsforeachDB 'Use [?]; Select DB_Name(),Name from sys.all_objects Where type=''U'' And is_ms_shipped =0'



Select * from #AllTables



Drop Table #AllTables