Query across Databases

• chilidogie

  SSChasing Mays

  Points: 607

  More actions

  February 24, 2009 at 11:52 am

  #201488

  I have 6 databases open under one instance of SQL-2005. Is it possible to query across databases ? When I open a query, I connect to the main database. However, to link to a table in one of the other databases (the others are change logs), I have to reconnect to that other database, and I lose the connection to my main database.

  Thank you !

• JestersGrind

  SSCrazy Eights

  Points: 8035

  More actions

  February 24, 2009 at 11:57 am

  #949574

  You can query across database using three part naming. For example:

  SELECT * FROM Database.Schema.Table

  Greg

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  February 24, 2009 at 11:57 am

  #949575

  You can query with a 3-part name:

  Database.ObjectOwner.Object

  Also, you can create a synonym in your database that refers to an object in another database.