Press Tab to expand wildcard

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Press Tab to expand wildcard

Postby GregBrown99 » Thu Feb 27, 2014 4:21 pm

If I create a new view, what has to happen before SQL Prompt will allow me to press TAB to expand the list of columns in the view.

For example, if I create a view myView, then create a query:
select *
from myView

I'm not prompted to "Press TAB to expand wildcard"

Is there something that has to happen in SqlServer before SQL Prompt picks up the new view?

Thanks.
GregBrown99
 
Posts: 2
Joined: Thu Feb 27, 2014 4:12 pm

Postby Aaron Law » Thu Feb 27, 2014 5:33 pm

Hi Greg,
You'll need to refresh the suggestions after creating the new view (pressing Ctrl+Shift+D or using refresh suggestions from the prompt menu will do it). This'll load the new view into Prompt's cache and allow it to offer suggestions such as expand wildcards.

Alternatively there's an experimental feature to automatically refresh suggestions when a change is detected on the database (found under SQL Prompt->Options->Experimental Features)
Aaron Law
 
Posts: 261
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby GregBrown99 » Thu Feb 27, 2014 6:46 pm

Thank you!
GregBrown99
 
Posts: 2
Joined: Thu Feb 27, 2014 4:12 pm


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests