What are the challenges you face when working across database platforms? Take the survey

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

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

Best Answer

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    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.

    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?


Sign In or Register to comment.