Select any function from one of your extensions that you don’t use and assign Ctrl Shift Q to it in the window that appears. I hope you have learned some new HANA Studio keyboard shortcuts today.On a Chromebook, how do I turn off the Ctrl Shift QQ? To do so, go to Chrome://extensions in your browser.Ĭlick “Keyboard shortcuts” at the bottom of the page. Just remember that for table suggestion, we need to write at least two lettersĪs 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: Similarly to find tables and statements, we can press CTRL+SPACE The below figure shows all schemas starting with letter S We can also Press CTRL+SPACE to find schema names, tables and to complete statements in SQL console 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 We have some Keyboard Shortcuts for SQL Editor also: It will generate three lines to write comment as shown below Generally we explain our written code using comments, so to generate element comment, Press CTRL+SHIFT+J To complete any word or show template proposals, Press CTRL+SPACE We also have Word Completion ability and ability to show template proposals in files in SAP HANA So to go to Last edited location of that file, Press CTRL+Q Lets say we created a File and then saved it. To open properties of any file, select that file and Press ALT+ENTER To open Declaration of an Object, Select that Object and Press F3 We also use SAP HANA Development Perspective a lot, so let me list few Keyboard Shortcuts that I use In this search, we can also Specify file extension: To search for a file in Workspace, Press CTRL+H 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īelow is a list of Shortcuts for opening any of the Views: Show View To create a New Project, Press ALT+SHIFT+N To search for Repository Objects, Press Ctrl + Shift + A So to maximize and minimize active Tab/Editor, Press CTRL+M Since HANA SPS05, we could double click on any Tab/Editor and open it in full screen So to collapse everything in Navigator, Press CTRL + SHIFT + NUM(/) We use System Navigator a lot to check Tables, Views, Decision Tables, Procedures etc and collapsing everything is a tedious task To switch between recently opened Perspectives, Press CTRL+F8 To switch between Views(like Job Log, History, Timeline etc), Press CTRL+F7 There is one more option to switch quickly between Editors/Tabs, Press CTRL+E Or to switch between Editors/Tabs, Press CTRL+SHIFT+E To switch between recently opened Editors/Tabs, Press CTRL+F6Īlternatively, we can also open Backward and Forward History for Editors/Tabs, Press ALT+LEFT or ALT+RIGHT To close all Tabs, we can Press CTRL+SHIFT+F4Īs we work a lot with these Tabs/Editors so switching between them is very important To close current Tab, we can Press CTRL+F4 Or Alternatively press CTRL+SHIFT+L to get list of Keyboard Shortcuts as shown below:Īs you can see it’s a very long list of Shortcuts, so I will mention few useful Shortcuts that I generally use:Īs we know when we work in HANA Studio, we open many Tabs/Editors(Views, SQL Console, Data Preview etc all open in New Tab) Now in SAP HANA Studio, we can get list of all Keyboard shortcuts: So I would just like to mention few shortcuts that I use frequently. Most of the work in HANA Studio is generally done graphically using Mouse and Clicks.īut we also have many Keyboard Shortcuts available in HANA Studio that would make working easier. As we all know HANA Studio is the most essential part of working with HANA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |