Shulou(Shulou.com)06/01 Report--

SQL Prompt is a practical SQL grammar prompt tool. It automatically retrieves according to the object name, syntax and code snippet of the database, and provides users with appropriate code choices. Automatic script settings make the code easy to read-especially useful when developers are not familiar with scripts. SQL Prompt can be installed and used, which can greatly improve the coding efficiency.

By default, SQL Prompt automatically and continuously displays code completion recommendations. This article mainly shows how to control this behavior when you need to reduce interference, such as when dealing with more complex coding issues that need to be carefully considered.

By default, SQL Prompt's code suggestion box pops up when it thinks it can provide useful advice, actually at every keystroke. This is not the way many of us want it to work, or at least not always. If you are working on a complex coding task that you do not want to be interrupted, you can choose to use Ctrl + Shift + P to turn autocomplete recommendations on and off. However, we do not recommend that you do this often, because each time the prompt for querying the database is triggered, its database metadata is refreshed. A better option is to always enable suggestions, but control their behavior. You have two choices: either stop the display often or stop it, unless you use Ctrl + Space to request them to change.

Here's how to do this: open the SQL Prompt menu, click options to get the options window, and then go to the suggestions > behaviors pane.

Automatic advice that is infrequent

By default, display code recommendations are enabled (if not enabled, enable it), and automatic display suggestions are also enabled. And set to 0 to 70 milliseconds (depending on the version of the prompt you installed). To enable these two options, simply increase the automatically recommended frequency to 5000 milliseconds, or whatever frequency you think is best for you.

Click OK to save the settings.

Now, the suggestion box will pop up only after a delay of 5 seconds. Don't forget that you can still get advice "on demand" by pressing Ctrl and then pressing the spacebar (Ctrl + Space).

Recommendations for demand only

If you want prompts to display suggestions only on demand, simply uncheck the Auto Show suggestions box and enable the Show Code suggestions box.

Click OK to save the settings. Now unless you click (Ctrl + Space), you will never see suggestions for auto-completion.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.