Show TOC

Working with SQL ConsoleLocate this document in the navigation structure

SQL Console allows you to write an SQL statement and analyze the query performance.

Context

SQL Console uses the most current query used in Data Preview. SQL Console supports:
  • only new Open SQL syntax
  • most of the ABAP source code features while working with queries. The table below lists features specific to SQL Console and how to use them:
Feature How to use?
Check In SQL Console, choose Check. This feature verifies the syntax of a query.
Note SQL Console also performs an automatic syntax check and instantly highlights any errors in syntax. For proper functioning of the automatic syntax check, ensure that the option Automatic Syntax check on all open ABAP source editors is selected in Eclipse. This option is available under the Eclipse menu option Start of the navigation path Windows Next navigation step Preferences End of the navigation path.
Run In SQL Console, choose Run to execute a query. In an SQL statement with multiple queries, if you want to execute a specific query, highlight the query and choose Run.
Note The Run drop-down menu contains following options:
  • History: This option lists previously executed queries in SQL Console. Use this option to remove specific queries from the list or to define the number of queries to be displayed in the list.
  • Clear History: This option removes all the previously executed queries, except the current query, from the History list.
  • Add To Favorites: This option allows you to add a query in the favorites section and reuse it for future reference.
  • Organize Favorites: This option allows you to work with queries in your favorites. You can add, remove, or move a query in the list.
Data Aging The Data Aging option allows you to view the most frequently accessed data (hot data) in your database. This feature is available only for the HANA database. The Data Aging option does not appear if you open Data Preview in other database.
Max Rows In SQL Console, enter a value for Max Rows. Data Preview considers only this value while displaying records. Maximum row value provided in the SQL statement is not considered.
Content Assist In SQL Console, press CTRL + spacebar.
Tooltip Support In SQL Console, press F2 on any DDIC artifact or DDIC component.
Query Performance SQL Console is split into two windows. The top window provides you the option of entering an SQL statement and the bottom window provides query related statistics.

Procedure

  1. In the Project Explorer view, choose an ABAP project.
  2. In the context menu of the selected project, choose SQL Console.

    The SQL Console appears and displays the executed query, query results, and query statistics.