1

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?

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Christian4145
  • 513
  • 1
  • 9
  • 31

1 Answers1

0

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.

Lars Br.
  • 9,949
  • 2
  • 15
  • 29
  • Do you mean: Ctrl-Shift-L what opens Help/Key Assist... ? Only some few shortcuts used within SQL Console are shown here. – Christian4145 Oct 27 '17 at 08:48
  • Then you can still look in the already mentioned preferences setting. – Lars Br. Oct 27 '17 at 08:49
  • Unfortunately these shortcuts seem to mostly only work outside SQL Console: i.e. How to 'uppercase' something? – Christian4145 Oct 27 '17 at 10:04
  • I’m pretty sure to have answered your questions. But ok, let’s have another one... afaik there is no uppercase command in the HANA SQL console editor and thus no shortcut for it either. – Lars Br. Oct 27 '17 at 10:24