MS-SQL - List all the tables names from the another database

Suppose i have a two database like Northwind and AdventureWork databases.
Currently I am use Northwind database.


So I want to show all the tables names from AdventureWork database.
It is look like this;

   1:  Use  Northwind

   2:  SELECT * FROM  AdventureWork.sys.tables

It will show all the tables names.