Menu
The SQL editor in DBeaver has this unsupportable feature of transforming all capital characters into lower case. This happens as you type, the most schizophrenic thing.
I have searched in the menus and the Preferences dialogue, but I can not find the setting to this feature. How can I switch it off?
757
To format an SQL text, select it and press Ctrl+Shift+F or right-click the selected text and click Format -> Format SQL on the context menu. To format a script to upper or lower case, highlight the SQL text, then right-click it and click Format -> To Upper Case / To Lower Case, respectively, on the context menu.
Right click on left column of SQL Editor and click Show / Hide Line Numbers from context menu.
To execute a query under the cursor or selected text, press Ctrl+Enter or right-click the query and click Execute -> Execute SQL Statement on the context menu. You can do the same using the main toolbar or main menu: SQL Editor -> Execute SQL Statement.
Got to Preferences > General > Editors > SQL Editor > SQL Formatting. Then over under Auto Format there is a box for Convert Keyword Case.
148
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
