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;
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