Remove schema from intellisense auto-fill.

Kostas_Ch

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.

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

Kostas_Ch

@cperez Hey, it worked just fine, thanks a lot.

cperez

Great News, glad to hear it.