Script files: SQL files that you want to run. If you select a data source as a target, IntelliJ IDEA displays a schema in which the script will be run. Target data source / schema: databases or schemas against which you want to run your database scripts. The fields that appear in the right-hand pane display the settings for the selected configuration type. To edit an existing run configuration, expand the Database Script node and select the run configuration that you want to edit from the list. To create a new run configuration, click the Add New Configuration icon ( ) and select Database Script. In the Run/Debug Configurations dialog, you can either create a new run configuration or edit an existing one. With the Navigation bar visible ( View | Appearance | Navigation Bar), choose Edit Configurations from the run/debug configuration selector. Select Run | Edit Configurations from the main menu. Open the Run/Debug Configuration dialog in one of the following ways: In IntelliJ IDEA, the maximum number of DML statements that you can run from an SQL file is 1000. Depending on your purposes, you can run SQL files using one of the following ways:Ĭreate new run configurations or edit the existing ones via a run configuration widget.Ĭreate new run configurations via Project tool window by running the selected file.Ĭreate new run configurations via Database tool window by running a file against the selected database or schema. SQL files are run against the selected databases or schemas using run configurations. For more information about running applications and other files, refer to Run applications. This page describes how to run SQL files using the Database Tools and SQL plugin. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Press Control+Alt+S to open the IDE settings and then select Plugins. The Database Tools and SQL plugin is available only in IntelliJ IDEA Ultimate. If the relevant features aren't available, make sure that you didn't disable the plugin. This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |