Provides intelligent code completion for SQL Server editors.
Moderators: Anu Deshpande, Aaron Law, David Priddle
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:
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?
- Posts: 2
- Joined: Thu Feb 27, 2014 4:12 pm
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)
- Posts: 261
- Joined: Fri Jun 28, 2013 10:56 am
- Location: Red Gate Software
Return to SQL Prompt 6
Who is online
Users browsing this forum: No registered users and 0 guests