In SAP HANA Studio (ver 2.2) there is a so called "SQL Console" where you can write your SQL code (sometimes also called "SQL Editor").
There are some keyboard shortcuts to improve productivity with this tool. What I found:
F8: execute Query
F9: execute Query where Cursor is (Query means SQL statement separated by semicolon)
Ctrl+Shift+Z: execute "Explain Plan for " + Query where Cursor is
Alt+F7: toggle between SQL and result window
Ctrl+F6: toggle between Editor windows (sometimes also Alt+Cursorkey)
F2: clear the Editor
Ctrl+Shift+O: format the Query
Ctrl+Z: Undo
AB+Ctrl+Space: autocomplete (where AB are the first two letters of the statement or object)
Are these the only shortcuts in SQL Console? Is there a way to start the SQL console by shortcut? Is there a way to connect by shortcut? Is there a way to use HANA studio without a mouse?
HANA Studio is an Eclipse application (more precisely a whole bunch of Eclipse plug-ins).
That means, keybindings are handled by Eclipse and you can use the Help
- Show Active Keybindings
menu action to get a list of all the currently active "shortcuts".
Generally speaking, HANA Studio is meant as a visual tool and mouse usage is largely required. However, you can define your own keybindings (e.g. for the "Open SQL Console" command) in the Eclipse preference settings.