How to: Modify IntelliSense Options
Most Microsoft IntelliSense options are on by default. You can turn off an IntelliSense option and instead invoke it through a menu command or keystroke combination.
To turn statement completion options off by default
On the Tools menu, click Options.
Expand Text Editor, expand either All Languages, Transact-SQL, or XML, and then click General.
Clear the check boxes for the Statement completion options that you do not want, and then click OK.
To modify Transact-SQL IntelliSense options
On the Tools menu, click Options.
Expand Text Editor, expand Transact-SQL, and then click IntelliSense.
Clear the check boxes for the IntelliSense options that you do not want.
To change the script size at which IntelliSense features are disabled, select a size from the Maximum script size list.
To change the casing applied to function names in completion lists, select a casing specification from the Casing for built-in function names list.
Click OK.