After a from clause is there a ways to restrict suggestions to just schemas first?

• 

  Hello,

  You should be able to restrict suggestions for certain schema's in SQL Prompt Options by using Connections -> Specifiy the databases you want to load suggestions for:
  

  This should only load suggestions for the schema's you specify, and then load suggestions for the objects in those schemas.

  Here is our documentation on how to use this option: https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory#Managingconnectionsandmemory-ManagingdatabaseconnectionsManagingdatabaseconnections

  I hope this helps.
  

  
  

  Kind regards,

  Mac_F March 11, 2020 17:37

  - 0 +
• 
  Just want to add, you can display schema (owner) names in the suggestions box by clicking the right arrow  in the bottom left corner of the suggestions box.

  

  The arrows only affect how object names are displayed in the suggestions box. The schema (owner) name is only inserted into your code when Qualify object names with owner name is selected on the Inserted Code > Qualification options page.
  

  
  

  Tianjiao_Li March 17, 2020 15:01

  - 0 +

Add comment

Please sign in to leave a comment.