• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

select database list which has perticular table exist in that from master database

select database list which has perticular table exist in that from master database from sql server 2008 express.
0
Masterabhi
Asked:
Masterabhi
  • 3
  • 2
1 Solution
 
Ioannis AnifantakisSoftware EngineerCommented:
huh?
0
 
Ioannis AnifantakisSoftware EngineerCommented:
You want to transfer the schema of an SQL Server 2008 express into MySQL Server?
0
 
MasterabhiAuthor Commented:
I m sorry  for half question, I wanted to access other databases from master .
Thank you, I already figured out.
0
 
MasterabhiAuthor Commented:
I did this way and got what I wanted to .
"SELECT column names FROM datasettable.dbo.tablename"
0
 
Ioannis AnifantakisSoftware EngineerCommented:
If I am not mistaken, you can accept your own solution.

That way you will be able to help others having the same problem as yours as they can search the database and find the solution.

If you can do that, you don't need to delete your own post with the answer - as to help other people.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now