User files
Professional feature: download PyCharm Professional to try.
Running SQL files
Run an SQL file
Right-click a data source.
Select Run SQL Script….
In the Select Path window, navigate to the SQL file that you want to apply.
Run an SQL file for several data sources
Select the necessary SQL file in the Project tool window.
Right-click the SQL file, select Run (or press Ctrl+Shift+F10).
In the Target data source / schema pane, click the Add button (
) and select the necessary data sources.To see a full list of data sources, click the Filter button.
Gif
note
You can run individual statements only for one data source at a time.
note
The statements can contain parameters. Before you run these statements, specify values of these parameters.
Run individual statements
Open an SQL file in PyCharm.
Click the statement that you want to execute. If you want to execute more than one statement, select (highlight) the necessary statements.
Press Ctrl+Enter or select Execute from the context menu.
Select the query console where you want to execute the statement.
note
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.
tip
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
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
Open settings by pressing Ctrl+Alt+S and navigate to .
Click the Add button
and select directories or files for which you want to change a dialect.Click Open.
Click the SQL Dialect cell and select the necessary dialect.
Apply changes and click OK.
Thanks for your feedback!