In the Project tool window ( View | Tool Windows | Project), select files that you want to run. In the Statements window, you can click Customize to define whether you want to see the chooser or always run the statement under the caret. Also, you can associate a session with a file by selecting Attach Session from the context menu of the file. Statements that you are going to execute are highlighted in a query editor.įor another example of running script files, see the following video at .įrom the list, you can associate a different session with the file, or remove the association between the file and the session ( Detach Session). You can switch between other entries to run another set of statements. ![]() In the Statements window, press Enter to run the selected statement. ![]() For more information about sessions, see Managing connection sessions. (Optional) If the SQL file is not connected to a data source, select or create a connection session in the list. Alternatively, open settings by pressing Ctrl+Alt+S and navigate to Tools | Database | Query Execution. To customize query execution settings, click the Сustomize link. Press Ctrl+Enter or select Execute from the context menu. IntelliJ IDEA executes only the selection. It can be a subquery or a group of statements. Open the Project tool window ( View | Tool Windows | Project) and double-click an SQL file.Ĭlick the statement that you want to execute.Īlso, you can select (highlight) the fragment of code that you want to execute. When you open a file that is larger than 20 MB, you see only first 2.5 MB of the file. In IntelliJ IDEA, you can open and run a file. Running statements and files Run statements from an open file Just type, press Ctrl+Enter, and run your code. You can use a query console in the same way as you use a terminal. The only difference is that the query console is already connected to a data source, so you can type and run your code right away. You can run a query from query consoles, scratch files, and user files.Ī database or query console does not differ from other SQL files like user files and scratches. You can run Run your code by using shortcuts, toolbar buttons and icons, a context menu, and run/debug configurations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |