Run SQL files

1. Open the Run/Debug Configuration dialog in one of the following ways:

   • Select Run | Edit Configurations from the main menu.

   • With the Navigation bar visible (View | Appearance | Navigation Bar), choose Edit Configurations from the run/debug configuration selector.

   • Press AltShiftF10 and then press 00.

2. In the Run/Debug Configuration dialog, you can either create a new run configuration or edit an existing one.

   • To create a new run configuration, click the Add New Configuration icon () and select Database Script.

   • To edit an existing run configuration, expand the Database Script node and select the run configuration that you want to edit from the list.

3. The fields that appear in the right-hand pane display the settings for the selected configuration type.

   • Target data source / schema: databases or schemas against which you want to run your database scripts. This setting is dialect-dependent.

     If you select a data source as a target, IntelliJ IDEA displays a schema in which the script will be run. It is the default schema.

   • Script files: SQL files that you want to run. To add files, click the Add button () and navigate to files that you want to run. If a script contains schema switching, you will see a warning ().

4. Click OK to apply the changes and close the dialog.

5. To run the configuration, click the Run <configuration_name> button ().

1. In the Project tool window (View | Tool Windows | Project), right-click the SQL file that you want to run, and select Run '<file_name>'. Alternatively, press AltShift0R.

2. Select the settings for your run configuration.

   • Target data source / schema: databases or schemas against which you want to run your database scripts. This setting is dialect-dependent.

     If you select a data source as a target, IntelliJ IDEA displays a schema in which the script will be run. It is the default schema.

   • Script files: SQL files that you want to run. To add files, click the Add button () and navigate to files that you want to run. If a script contains schema switching, you will see a warning ().

   

3. Click Run.

1. In the Database tool window ( View | Tool Windows | Database) , right-click a data source, or a schema and select SQL Scripts | Run SQL Script….

2. In the file browser window that opens, navigate to the SQL file that you want to run and click Open.

   

3. Select the settings for your run configuration.

   • Target data source / schema: databases or schemas against which you want to run your database scripts. This setting is dialect-dependent.

     If you select a data source as a target, IntelliJ IDEA displays a schema in which the script will be run. It is the default schema.

   • Script files: SQL files that you want to run. To add files, click the Add button () and navigate to files that you want to run. If a script contains schema switching, you will see a warning ().

   

4. Click Run.

1. Open the Project tool window, navigate to the SQL file, and select it.

2. Drag the SQL file to the data source or schema in Database tool window that you want to run it against.

3. Select the settings for your run configuration.

   • Target data source / schema: databases or schemas against which you want to run your database scripts. This setting is dialect-dependent.

     If you select a data source as a target, IntelliJ IDEA displays a schema in which the script will be run. It is the default schema.

   • Script files: SQL files that you want to run. To add files, click the Add button () and navigate to files that you want to run. If a script contains schema switching, you will see a warning ().

   

4. Click Run.

On top of running applications from the editor, you can run single files using a dedicated option on the toolbar. The run and debug buttons are active and allow you to instantly run the currently opened file.

1. In the editor, open the file that you want to run.

2. Click next to the Current File option on the toolbar.

3. Select the settings for your run configuration.

   • Target data source / schema: databases or schemas against which you want to run your database scripts. This setting is dialect-dependent.

     If you select a data source as a target, IntelliJ IDEA displays a schema in which the script will be run. It is the default schema.

   • Script files: SQL files that you want to run. To add files, click the Add button () and navigate to files that you want to run. If a script contains schema switching, you will see a warning ().

   

4. Click Run.

You can access other runners from the submenu as well: expand the list and click the right arrow next to Current File. From the menu that opens, you can debug the code, run it with coverage, profile it, or open the run configuration to specify more options.