Refresh suggestions is limited to current connection

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Refresh suggestions is limited to current connection

Postby kevriley » Fri Dec 21, 2012 11:56 am

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.
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests