Way to force schema on a registered server group for autocomplete/intellisense
Michael_Andrews
Posts: 7 Bronze 1
in SQL Prompt
I have a registered group of servers in sql server and there are 38 databases in them. The schema on them is mostly identical, outside of a few tables we use for migrations and such that I don't care about. Problem is, I can't get intellisense or autocomplete when I query them all, and I'm assuming it's because of that. Is there some config or setting I can tweak to tell sql prompt that regardless of what it sees on those servers, to just go with a defined schema from one of those databases?
Tagged:
Answers
Apologies for the delay, To manage IntelliSense and autocomplete issues in SQL Prompt when querying multiple databases with similar schemas, you can configure the settings to include or exclude certain databases or schemas. Here are the steps you can follow:
- Open the SQL Prompt menu and select Options.
- Navigate to the Suggestions > Connections page.
- Under the Databases section, choose an option from the dropdown to either include or exclude certain databases/schemas.
- Enter the names of the server, database, and schema that you want the option to apply to. You can use
You can read more here: Managing connections and memory, Please let me know if you have any more question.*
and?
as wildcards for matching multiple or single letters, respectively.Best,
Hassan
Product Support Engineer
Apologies for the delay, To manage IntelliSense and autocomplete issues in SQL Prompt when querying multiple databases with similar schemas, you can configure the settings to include or exclude certain databases or schemas. Here are the steps you can follow:
- Open the SQL Prompt menu and select Options.
- Navigate to the Suggestions > Connections page.
- Under the Databases section, choose an option from the dropdown to either include or exclude certain databases/schemas.
- Enter the names of the server, database, and schema that you want the option to apply to. You can use
You can read more here: Managing connections and memory, Please let me know if you have any more question.*
and?
as wildcards for matching multiple or single letters, respectively.Best,
Hassan
Product Support Engineer