Limitation for the SQL file size is 20 MB. When you open a file that is larger than 20 MB, you see only the first 2.5 MB of the file.

In the console menu, you can associate a different console with the file, or remove the association between the file and the console (Detach Console). Otherwise, you can associate a console with a file by selecting Attach Console from the context menu of the file.

Configuring a dialect for SQL files

For better coding assistance, assign an SQL dialect to an SQL file. An SQL dialect is a DBMS-specific version of SQL.

PhpStorm lets you specify the SQL dialect for an individual file or all SQL and DDL files that can be stored in a directory, in your project, or on your computer.

Specify a dialect for a single SQL file

Click the dialect list, which is in the upper-right corner of the window.

Select a dialect from the dialect list.

Specify a dialect for multiple SQL files

Click the dialect list, which is in the upper-right corner of the window.

Select SQL Dialects.

In the SQL Dialects dialog, click the Add button and select directories or files for which you want to change a dialect.