Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

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?

Thanks.

Comments

  • 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)
Sign In or Register to comment.