<div>
And if you wanted to join from the current database to tables in another database:<br />
<br />
select * from currentdbtable t1 inner join otherdatabase.owner.tablen<wbr />ame t2<br />
on t1.key=t2.key
</div>


And if you wanted to join from the current database to tables in another database:

select * from currentdbtable t1 inner join otherdatabase.owner.tablename t2
on t1.key=t2.key

<div>
aah, didn't know you had to specify the owner as well.<br />
<br />
Cheers.
</div>


aah, didn't know you had to specify the owner as well.

Cheers.

<div>
Good deal. &nbsp;Always a good habit to get into to always include the owner...
</div>


Good deal.  Always a good habit to get into to always include the owner...

<div>
What do I have to do, &nbsp;so that the table in database A is available to all databases (B, C,...) In a way that any queries done by connecting to n B and C looks like the table is in B and C.<br />
I do not want to use the fully qualified name nor do I want to change my code to add openquery statements.<br />
<br />
The situation is I'm using dotnet code to query two databases that where split out of one.<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>


What do I have to do,  so that the table in database A is available to all databases (B, C,...) In a way that any queries done by connecting to n B and C looks like the table is in B and C.
I do not want to use the fully qualified name nor do I want to change my code to add openquery statements.

The situation is I'm using dotnet code to query two databases that where split out of one.











<div>
<div class="content wysiwyg-content">
Ok, easy question.<br />
<br />
How do you link tables in SQL Server? &nbsp;That is, how do you access tables from other databases (on the same SQL Server)?
</div>
</div>


Ok, easy question.

How do you link tables in SQL Server?  That is, how do you access tables from other databases (on the same SQL Server)?

Link tables in SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.