Keyboard Shortcuts in HANA Studio
Hi Everyone,
As we all know HANA Studio is the most essential part of working with HANA.
Most of the work in HANA Studio is generally done graphically using Mouse and Clicks.
But we also have many Keyboard Shortcuts available in HANA Studio that would make working easier.
So I would just like to mention few shortcuts that I use frequently.
Now in SAP HANA Studio, we can get list of all Keyboard shortcuts:
Just Go to Help -> Key Assists
Or Alternatively press CTRL+SHIFT+L to get list of Keyboard Shortcuts as shown below:
As you can see it’s a very long list of Shortcuts, so I will mention few useful Shortcuts that I generally use:
To Open Help, Press F1
As we know when we work in HANA Studio, we open many Tabs/Editors(Views, SQL Console, Data Preview etc all open in New Tab)
To close current Tab, we can Press CTRL+F4
To close all Tabs, we can Press CTRL+SHIFT+F4
As we work a lot with these Tabs/Editors so switching between them is very important
To switch between recently opened Editors/Tabs, Press CTRL+F6
Alternatively, we can also open Backward and Forward History for Editors/Tabs, Press ALT+LEFT or ALT+RIGHT
Or to switch between Editors/Tabs, Press CTRL+SHIFT+E
There is one more option to switch quickly between Editors/Tabs, Press CTRL+E
To switch between Views(like Job Log, History, Timeline etc), Press CTRL+F7
To switch between recently opened Perspectives, Press CTRL+F8
We use System Navigator a lot to check Tables, Views, Decision Tables, Procedures etc and collapsing everything is a tedious task
So to collapse everything in Navigator, Press CTRL + SHIFT + NUM(/)
Since HANA SPS05, we could double click on any Tab/Editor and open it in full screen
So to maximize and minimize active Tab/Editor, Press CTRL+M
To search for Repository Objects, Press Ctrl + Shift + A
To create a New Project, Press ALT+SHIFT+N
To create a New Object, Press CTRL+N
To open any View, Press ALT+SHIFT+Q Z
It’s a pretty tough combination and for achieving this combination, press Press ALT+SHIFT+Q keys together and then release them and then press Z again
Below is a list of Shortcuts for opening any of the Views:
Show View | Alt+Shift+Q Q | |
Show View() | Alt+Shift+Q Z | |
Show View(Breakpoints) | Alt+Shift+Q B | |
Show View(Cheat Sheets) | Alt+Shift+Q H | |
Show View(Console) | Alt+Shift+Q C | |
Show View(Declaration) | Alt+Shift+Q D | |
Show View(Error Log) | Alt+Shift+Q L | |
Show View(Javadoc) | Alt+Shift+Q J | |
Show View(Outline) | Alt+Shift+Q O | |
Show View(Package Explorer) | Alt+Shift+Q P | |
Show View(Problems) | Alt+Shift+Q X | |
Show View(Search) | Alt+Shift+Q S | |
Show View(Synchronize) | Alt+Shift+Q Y | |
Show View(Type Hierarchy) | Alt+Shift+Q T | |
Show View(Variables) | Alt+Shift+Q V |
To search for a file in Workspace, Press CTRL+H
In this search, we can also Specify file extension:
We also use SAP HANA Development Perspective a lot, so let me list few Keyboard Shortcuts that I use
To open Declaration of an Object, Select that Object and Press F3
To Check a file, Press CTRL+F2
To Activate a file, Press CTRL+F3
To open properties of any file, select that file and Press ALT+ENTER
Lets say we created a File and then saved it. Then later on we edited that file.
So to go to Last edited location of that file, Press CTRL+Q
We also have Word Completion ability and ability to show template proposals in files in SAP HANA
To complete any word or show template proposals, Press CTRL+SPACE
Generally we explain our written code using comments, so to generate element comment, Press CTRL+SHIFT+J
It will generate three lines to write comment as shown below
We have some Keyboard Shortcuts for SQL Editor also:
To execute Query, Press F8
To execute only the Query where Cursor is, Press F9 (Note: Just make sure that different queries are separated by a Semicolon) – Thanks José Carlos Méndez for this info
To clear the Editor, Press F2
To format the Query, Press CTRL+SHIFT+O
To undo any changes, Press CTRL+Z
To open Explain Plan, Press CTRL+SHIFT+Z
We can also Press CTRL+SPACE to find schema names, tables and to complete statements in SQL console
The below figure shows all schemas starting with letter S
Similarly to find tables and statements, we can press CTRL+SPACE
Just remember that for table suggestion, we need to write at least two letters
As seen in above image, we are also getting, whole select statement syntax, so lets say if I select “complete select syntax“, I will see the below figure:
I hope you have learned some new HANA Studio keyboard shortcuts today.
To create your own customized Shortcuts, check my document Creating your own shortcuts for HANA Studio
Thanks for your time
Regards,
Vivek
Very useful tips and helpful too. thanks for sharing vivek
Thanks Raman,
You are always the first person to like and comment on my blogs.
Thanks for always supporting me
Regards,
Vivek
Good one. Thanks for sharing.
Thanks Srinivas!
Regards,
Vivek
Hi Vivek ,
Thanks for sharing
good one
Regards
Prashanth
Thanks Prashanth
Regards,
Vivek
Nice Vivek...Good Work
Thanks Naveen!
Regards,
Vivek
Hi Vivek,
Good job...Nicely presented...Thanks for sharing 🙂
Regards
Krishna Chaitanya.
Thanks Krishna 🙂
Regards,
Vivek
Dear Vivek,
Thanks for sharing the useful info.
regards
kartik
Thanks Kartik,
Regards,
Vivek
Hi Vivek,
good job.
All the best,
Andy.
Thanks Andy
Regards,
Vivek
Nice post Vivek this will definitely be helpful..
Thanks Vivek! 🙂
Rama
Thanks Vivek for sharing such an important details.
Regards
Zarif
Hi,
Nice work as it will help the developers to reduce those cumbersome time which we take to
go to the perticular place by manual navigation.
Regards
praveen
I got a question to "To execute Query, Press F8" as F8 actually executes all queries unless you select (highlight) the fragment that has to be executed.
Have you happened to find the shortcut for executing only the query, where the cursor actually is?
Thanks.
If you want to execute just that particular query, you can use F9.
I really appreciate the work you have done, you explained everything in such an amazing and simple way. Gained some insights about sap hana. Thank you so much.
请问如何设置SQL的关键字的自动转大写?自动提示输入的字段名?
How to set the automatic capitalization of SQL keywords? Automatically prompt for the field name entered?
thanks.