Thursday, August 5, 2010

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.

No comments:

Post a Comment