SAP HANA Database Explorer 2.0 SP 12 introduces numerous new features and enhancements to existing features.
Highlighted below are two new features that have been introduced to improve the user experience of the SQL console in the database explorer.
For a full list of new features and enhancements, see What’s New in SAP HANA Database Explorer.
- New Statement Help Panel
Check out the new Statement Help panel in the SQL console, which shows contextual help documentation for the selected statement in the console. Click the Show/Hide Statement Help button to toggle the panel on or off as needed.
You can also click the provided link to open the SQL reference topic for your statement in the Help Portal.
The panel also shows detailed information about Tables and Views, Procedures and Functions, and SQL Functions. Table and view columns can also be drag and dropped into the SQL console.
*The screenshot below uses the Jobs | JobProgress.slq query from the Statement Library.
- SQL History Tab
The new SQL History tab shows the last 50 statements that were successfully executed. The statements are shown in order of most recently run.
You can also right-click a statement and choose to either Insert it into your SQL console or copy it to your clipboard. Hovering over a statement shows the full statement syntax.
For more information about these features and running queries in the SQL console, see Querying the Database.