How can we help you today? How can we help you today?

Remove schema from intellisense auto-fill.

Hello,

I was wondering that when working on a single-schema DB in SSMS, would it be possible to remove schema name from tables/views when the respective name is filled by the intellisense? 

Thanks in advance.
Kostas_Ch
0

Comments

3 comments

Sort by
  • cperez
    Hi Kostas_Ch,

    Thanks for reaching out to Redgate Software with your SQL Prompt inquiry, with respect to being able to remove schemas from intellisense auto-fill I was able to find the following entry which should answer your question:

    = = = = =

    The suggestions box is automatically widened to allow space for the schema names, shown in grey to the left of the suggestions:

    To hide the list of schema (owner) names, click the left arrow   

    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.

    = = = =

    Could you try disabling the 'Qualify object names with owner name' Prompt setting and seeing if you have any change in behavior?

    https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-suggestions-into-your-code#Insertingsuggestionsintoyourcode-DisplayingschemanamesDisplayingschema(owner)names

    cperez
    0
  • Kostas_Ch
    @cperez Hey, it worked just fine, thanks a lot.
    Kostas_Ch
    0
  • cperez
    Great News, glad to hear it.
    cperez
    0

Add comment

Please sign in to leave a comment.