posted 5/27/2010 6:48:16 PM by Raghav Khunger
I like working with "Red Gates" tools, they are awesome. SQL Prompt (one of their tools) is a code auto-completion and formatting tool for writing SQL queries. While working with SQL prompt I noticed that it automatically qualify object names with owner name .i.e if the owner name is "dbo" it makes the query like this:
Select * from dbo.mytable
As you are seeing dbo has been added while qualifying objects. I need to remove this feature as I don't want to put restrictions on the clients to have the owner name i.e I want the query to remain
Select * from mytable
To make it that happen I did the following steps
Below is the screenshot:
After doing it my SQL prompt stopped qualifying the object names with owner name.
Do let me know your feedback, comments.
Raghav Khunger (Member since: 4/19/2009 1:46:52 AM)
View Raghav Khunger 's profile
Leave a comment
It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.
enter your email address: