question

tcarnahan avatar image
tcarnahan asked

SSMS Intellisense

Is there a way to edit Intellisense in SSMS (2008 or higher)? When I type certain words, I get a totally undesireable outcome. Example: I want a CASE statement ... I get CASE_DEFINITION ... and it is annoying. I would like to be able to edit its list and remove CASE_DEFINITION.
ssmsintellisense
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SirSQL avatar image
SirSQL answered

There's no way that I know to edit this list (it's something people have been requesting for a while).

Honestly, I'd spend the $195 for SQLPrompt from RedGate (https://www.red-gate.com/products/sql-development/sql-prompt/index) and turn off Intellisense completely.

*Note: I do not work for, nor are affiliated with RedGate in any capacity

4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

That was what I was afraid of ... I would get SQL Prompt if my company was willing to purchase it ... Thanks for the quick response!
0 Likes 0 ·
For that price point and the huge productivity gains that SQLPrompt will provide (not just intellisense but the formatting, snippets as well) I think it's worth raiding your bank account for your own license.
0 Likes 0 ·
I've only worked for Red Gate for 18 months, but I've been using Prompt for years & years. I guarantee, even non-profits can see the benefit of the tool and pay the $195. It's well worth it.
0 Likes 0 ·
SQL Complete ( http://www.devart.com/dbforge/sql/sqlcomplete/editions.html) does the job too: just $79. It's a bargain :)
0 Likes 0 ·
Shawn_Melton avatar image
Shawn_Melton answered
[Atlantis Interactive][1] has created a nice free alternative to SSMS called [SQL Everywhere][2]. I am not sure if the intellisense can be adjusted but it works alot better than SSMS out of the box, so it might suffice for you as is. It is a very good tool for being free and has some nice features in it. [1]: http://www.atlantis-interactive.co.uk/ [2]: http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.