Hide items from autocomplete menu in SQL Server Management Studio

Does anybody know how to hide specific things from this menu?

I want my columns be at number one priority, followed by functions and constants. I don’t need all this system variables there.

In Visual Studio I can show those entries by category. Does a feature like this exists for the SQL Server Management Studio as well?

enter image description here

>Solution :

In the SSMS menu under Tools/Options, you can find that this option is not available:

enter image description here

One option is to type category. (= your table-name followed by a dot), but this defeats the use of Intellisense 😉

Slightly better would be: SELECT * FROM category c WHERE c. which should start showing the fields for this table.

Leave a Reply