How can we help you today? How can we help you today?

Press Tab to expand wildcard

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
0

Comments

2 comments

Sort by
  • Aaron L
    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 L
    0
  • GregBrown99
    Thank you!
    GregBrown99
    0

Add comment

Please sign in to leave a comment.