What are the challenges you face when working across database platforms? Take the survey

Press Tab to expand wildcard

GregBrown99GregBrown99 Posts: 3
edited February 27, 2014 12:46PM in SQL Prompt
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?



  • Options
    Aaron LAaron L Posts: 596 New member
    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)
  • Options
    Thank you!
Sign In or Register to comment.