SQL Dialects
for Windows and Linux
for macOS
This page lets you specify the SQL dialects (DBMS-specific versions of SQL) used in various scopes.
Dialect settings
Dialect options
When specifying a dialect, in addition to particular dialects, you can select:
- <None> or <Clear>. As a result, a dialect from a higher level is inherited.
- <Generic SQL>. This means that no particular dialect is specified. As a result, basic SQL92-based coding assistance is provided including completion and highlighting for SQL keywords, and table and column names. Syntax error highlighting is not available. So the file contents are always shown as syntactically correct. Also, automatic code reformatting isn't possible.
Example
Say, most of the SQL script files on your computer are for PostgreSQL. In the current project, you are developing the scripts for Oracle but in one of the directories in your project there are the scripts for MySQL. In such a situation, you'd specify:
See Also
Language and Framework-Specific Guidelines:
Last modified: 18 July 2017