Hide other databases from suggestions
An option to not suggest other databases while populating the suggestion dropdown would be nice. In our system, we have discrete databases for each client, and so our development machines have hundreds of databases on them. When attempting to type a table name, it is not uncommon for SQL Complete to suggest a database name that matches the abbreviation, but for our use case this will never be ideal (queries are basically never ran across databases, and when they are we can deal with having to manually type out the database name).
At the very least, I think it would be sufficient to alter the ranking algorithm so that the current database's tables always take precedence over other database names when providing suggestions.
The one exception to this might be for the USE clause, but since you do contextual suggestions I don't think it would be difficult to allow suggestions of other databases in this context, but not in the FROM clause, etc.
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your patience!
We would like to suggest using the option "Do not load suggestions for the following databases."
There's currently no option for ranking.
Best,
Devart Support Team