Red Gate forums :: View topic - Refresh suggestions is limited to current connection
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Refresh suggestions is limited to current connection

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Fri Dec 21, 2012 11:56 am    Post subject: Refresh suggestions is limited to current connection Reply with quote

SQL prompt does support cross database queries, but if you refresh suggestions, it doesn't refresh the suggestions of the remote database, just the one you are currently connected to.

So for example, open a query window connected to DatabaseA

start typing 'select * from DatabaseB.dbo.' and you'll get the table suggestions from DatabaseB.

In another window, connect to DatabaseB and create a new table

Return to original window and refresh suggestions (Ctrl-Shift-D), but new table does not show.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group