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

pwo311

We have many schemas in databases. Can we restrict what is prompted to schemas first and then when entered, objects in the schema?

Tianjiao_Li

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.

Mac_F

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,