SSMS 17.1 stopping autocomplete suggestion of variable types

Question

I'm trying to figure out how to stop autocomplete suggestion of variable types while keeping the autocomplete suggestion for table and column names (so disabling autocomplete function is note the solution).

For example, if I type NVARCHAR, the autocomplete suggests nvarchar and once I continue typing, it automatically correct the word.

It is a convention of my company to write variable types uppercase and the autocomplete function transform them to lower case each time. I know i can hit "Esc" to avoid the correction, but do this each single time is something really annoying.

UPDATE: Actually the same problems happens when tiping for example IS:

CASE WHEN colName IS NULL

becomes

CASE WHEN colName IS_CALLERSIGNED NULL

if i don't press esc

Answer 1

For example, if i type NVARCHAR, the autocomplete suggests nvarchar and once i continue typing, it automatically correct the word.

This autocompletion is not just a "convention", SQL Server types that you can see querying sys.types are all lowercase, and this is a good reason to use them ALWAYS lowercase:

if one day your code migrates to a server with case sensitive collation, no one of your UPPERCASE types will be recognized as system type.

So yours is not a good convention and I think you cannot change this at least in SSMS because they(MS) are aware of this possible issue.

You can look for some customizable code formatter in internet