Any way to remove the "dbo." in front of join suggestions?

montek · April 11, 2007 11:05AM

I would prefer the suggested joins NOT include dbo. in front of tables when they're in the same schema/owner. Is this possible?

Ben Pinchen · April 18, 2007 1:32PM

I've looked into this and it is a bug in the software. I've notified the developers and they are hopefully going to fix this in a future version of SQL Prompt.

montek · April 18, 2007 1:51PM

Great, thank you. I'm surprised no one else has noticed or commented about this. Unfortunately this issue is really preventing me from getting my whole team to use this product, which we purchased in advance of it being ready. The sooner, the better.

montek · June 19, 2007 10:39AM

Can you tell me if this is slated to be fixed in the next version and when that might be released?

Bart Read · July 18, 2007 12:46PM

This will be fixed in the 3.5 final release. We now honour the value of the "Qualify object names" option when inserting JOIN conditions exception where columns in another database are referenced. The following SQL illustrates this:

-- Note that these examples are for illustrative purposes
-- only. They use AdventureWorks 2005 and won't execute because
-- you have to qualify object names if their owner is not
-- your default schema.

USE &#91;master&#93;
GO

-- Working cross-database with qualify object names disabled

SELECT * FROM
&#91;AdventureWorks&#93;..&#91;Product&#93; INNER JOIN &#91;AdventureWorks&#93;..&#91;BillOfMaterials&#93;
ON &#91;AdventureWorks&#93;.&#91;Production&#93;.&#91;Product&#93;.&#91;ProductID&#93; = &#91;AdventureWorks&#93;.&#91;Production&#93;.&#91;BillOfMaterials&#93;.&#91;ComponentID&#93;

GO

USE &#91;AdventureWorks&#93;
GO

--	With qualify object names disabled

SELECT * FROM
&#91;Product&#93; INNER JOIN &#91;BillOfMaterials&#93;
ON &#91;Product&#93;.&#91;ProductID&#93; = &#91;BillOfMaterials&#93;.&#91;ComponentID&#93;

-- With qualify object names enabled

SELECT * FROM
&#91;Production&#93;.&#91;Product&#93; INNER JOIN &#91;Production&#93;.&#91;BillOfMaterials&#93;
ON &#91;AdventureWorks&#93;.&#91;Production&#93;.&#91;Product&#93;.&#91;ProductID&#93; = &#91;AdventureWorks&#93;.&#91;Production&#93;.&#91;BillOfMaterials&#93;.&#91;ComponentID&#93;

Hope that helps.

Thanks,
Bart

Any way to remove the "dbo." in front of join suggestions?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

Any way to remove the &quot;dbo.&quot; in front of join suggestions?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

Any way to remove the "dbo." in front of join suggestions?