Is it possible to stop intellisense for .sql files

问题:

I'm using Visual Studio 2010 to edit DDL for a MySQL database in a file with a ".sql" extension. The IDE insists on providing red squiggles under perfectly legal MySQL syntax, presumably as it's not legal SQL Server syntax.

Is it possible to disable syntax highlighting for .SQL files?

Or, better still, is MySQL IntelliSense highlighting available?

回答1:

Visual Studio 2010

Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense

Uncheck "Enable IntelliSense".

Visual Studio 2012 & 2013

Tools -> Options -> Text Editor -> SQL Server Tools -> IntelliSense

Uncheck "Underline errors"

Note that you have to close then re-open any .sql files you may have open.

回答2:

Don't have VS 2010 in front of me now but it should be something close to

Tools -> Options -> Text Editor -> [Language] -> General -> Statemenent Completion

Uncheck the checkbox for Auto List Members