Friday, 31 January 2014

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

                                   List all the tables names from the another database

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


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


   1:  Use  Employee
   2:  SELECT * FROM  Department.sys.tables

It will show all the tables names.

No comments:

Post a Comment