Data Management (DMS) provides the Cmd Tab feature for you to write and execute SQL statements in the form of commands. The executed SQL statements and execution results are displayed in the upper part of the Cmd Tab tab. This topic describes the graphic user interface (GUI) of the Cmd Tab tab.

Prerequisites

  • The database to be queried is a relational database, such as a MySQL, an Oracle, or an SQL Server database.
  • You have permissions to query the database or table that you want to query. For more information about how to apply for permissions, see Permission management.

Procedure

  1. Log on to the DMS console.
  2. In the top navigation bar, move the pointer over the More icon and choose SQLConsole > Cmd Tab.
  3. Select the database that you want to query from the drop-down list or enter a keyword in the field to search for the database. After you select the database, click Confirm.
  4. Enter the SQL statement to be executed in the lower part of the Cmd Tab tab and press Ctrl+Enter or click Execute to execute the SQL statement.
    GUI of the Cmd Tab tab
    Table 1. GUI of the Cmd Tab tab
    No. Section Description
    1 Visual operation section For more information, see the GUI of the SQLConsole in Overview.
    2 Extended feature section
    3 Execution result section In this section, the execution results of the current SQL statement and historical SQL statements are displayed.
    Note You can click the Add icon icon to add multiple query tabs.
    4 Command running section In this section, you can write an SQL statement and press Ctrl+Enter or click Execute to execute the SQL statement. You can also click Clear screen to clear all executed SQL statements and execution results.