![]() ![]() Most of the following commands are accessible from main menu, toolbar or right-click menu. Don’t miss our next article where you can learn more about them. DBeaver will be even more useful if you use these shortcuts to edit your SQL queries. But we can also suggest a few cool shortcuts to help write new scripts. We have shared convenient shortcuts for working with existing SQL scripts. If you want to scroll down conveniently and view your script in the editor after the query execution, you can hide the results panel and then show it again using the shortcut Ctrl+6. But it wont help if socket timeout exception occurs. If you cant stop query then you may try to force disconnect (click on the connection in navigator tree and click disconnect in main toolbar or context menu). The selection will automatically be transferred to the copy you have made. If yes you may try to stop/cancel current running query. To do this, just select them and press Ctrl+Alt+Down ( Cmd+Option+Down on macOS). Sometimes you might want to copy and paste one or several queries. Instead, you can use shortcuts Alt+Down and Alt+Up. But to switch between them, you also do not need to use the mouse. Now you know how to run a query using the keyboard. If you want to execute the full script, press Alt+X. But here, the same shortcut Ctrl+Enter comes to your aid, which you can run the selected query through. To execute a statement or a full script, you can use the corresponding buttons in the left toolbar of the SQL Editor. Please note that all of your editors must be closed to use this shortcut. ![]() If you have not previously selected any connection, you will see a window with a choice of the data source. It opens the last script for the connection which you would have selected in the tree. You can get back to working with a recent script using the shortcut Ctrl+Enter. This can be done in two ways: from the context menu of the SQL Editor or using the shortcut Ctrl+Alt+Shift+O. For example, if one of your colleagues shared an SQL file with you, you can upload it from your system. But there is a way to remove this option in Editor > Editor SQL > SQL Processing. Moreover, this is available not only for scripts that have been created and saved through our app. DBeaver simply consider the newline/breakline as a statement separator. With DBeaver, you can either write a script from scratch or use an existing one. Did you know that you can work with SQL scripts almost without using your mouse? In this article, we are going to talk about some useful shortcuts for SQL Editor that would be helpful in working with existing scripts.
0 Comments
Leave a Reply. |