Way to force schema on a registered server group for autocomplete/intellisense

Michael_AndrewsMichael_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:
· Share on Twitter

Answers

  • hassan_imamhassan_imam Posts: 55 Bronze 1
    Hi Michael,

    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:
    1. Open the SQL Prompt menu and select Options.
    2. Navigate to the Suggestions > Connections page.
    3. Under the Databases section, choose an option from the dropdown to either include or exclude certain databases/schemas.
    4. Enter the names of the server, database, and schema that you want the option to apply to. You can use * and ? as wildcards for matching multiple or single letters, respectively.
    You can read more here: Managing connections and memory, Please let me know if you have any more question. 

    Best, 

    Hassan 
    Product Support Engineer 
     

    · Share on Twitter
  • hassan_imamhassan_imam Posts: 55 Bronze 1
    Hi Michael,

    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:
    1. Open the SQL Prompt menu and select Options.
    2. Navigate to the Suggestions > Connections page.
    3. Under the Databases section, choose an option from the dropdown to either include or exclude certain databases/schemas.
    4. Enter the names of the server, database, and schema that you want the option to apply to. You can use * and ? as wildcards for matching multiple or single letters, respectively.
    You can read more here: Managing connections and memory, Please let me know if you have any more question. 

    Best, 

    Hassan 
    Product Support Engineer 
     

    · Share on Twitter
Sign In or Register to comment.