Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

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?

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

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.

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading