PhpStorm 2016.1 Help

SQL Dialects

File | Settings | Languages and Frameworks | SQL Dialects for Windows and Linux
PhpStorm | Preferences | Languages and Frameworks | SQL Dialects for OS X

This page lets you specify which SQL dialects are used in your project.

A dialect may be set at the project level, and also at the level of a directory or a file.

If a dialect is not specified explicitly, it is inherited from a higher hierarchical level.

The dialects specified explicitly are shown in black. The inherited values are shown in gray italic.

File/Directory This column shows the hierarchy of files and folders in the project. Each row corresponds to a directory or a file.
SQL DialectSpecify the SQL dialect to be used.

Click the cell of interest and select the necessary option from the list.

In addition to particular dialects, you can select:

  • Clear. This will clear the corresponding cell. As a result, an option from a higher hierarchical level will be inherited.
  • <Generic>. 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, code reformatting isn't possible.

See Also

Language and Framework-Specific Guidelines:

Last modified: 12 July 2016