Refresh suggestions
torsten.strauss
Posts: 270 Silver 3
in SQL Prompt
Hi Redgate Team,
since the last(?) version the automatic and manual refresh of suggestion is not working properly anymore.
Dropped object are still in the suggestion list (intellisense).
Thanks for looking into this!
Version 9.0.5.3501
Torsten
since the last(?) version the automatic and manual refresh of suggestion is not working properly anymore.
Dropped object are still in the suggestion list (intellisense).
Thanks for looking into this!
Version 9.0.5.3501
Torsten
Tagged:
Best Answers
-
krzysztofkroczak Posts: 55 Silver 2Hi @torsten.strauss,
I think that refreshing suggestions is still working properly, probably you are in the same script where you've created and deleted something (tables, sps, etc.).
We add objects to suggestions when we detect a create statement of something.
We do it like this because otherwise, it would not be possible to give any suggestions in the script as in some sense it's still not invoked and we can't predict what is the real purpose of the user.
Best regards,
Krzysztof -
torsten.strauss Posts: 270 Silver 3Hi Krzysztof!
Thanks for clarification!
You are right, the create statement is in the same script.
I was thinking the suggestion is driven by sys.objects but your approach is smarter.
Torsten
Answers
Maybe I am wrong but the logic considering your approach should be:
What do you think?
Torsten
We chatted on the team and we think that some people still want to have that suggestion, because they writing some bigger script and they don't go through one by one statement.
If you think that it is still valuable to change that behaviour would you mind put it on UserVoice.
Best regards
Krzysztof