This topic describes how to manage a database, such as querying or updating data in the database, on the SQLConsole tab in the Data Management (DMS) console.

Prerequisites

You have the permissions to query, modify, and export data in a database. For more information, see Manage permissions.

Go to the SQLConsole tab

Log on to the DMS console.

Query data

  1. Go to the SQLConsole tab.
  2. On the SQLConsole tab, enter an SQL query statement in the SQL editor and click Execute on the top of the SQL editor.
    Enter an SQL query statement
    Note
    • Each query result set is displayed on a tab below the SQL editor. You can double-click an element in the query result set and modify the element as needed. Modify a query result set
    • You can double-click the name of a table in the navigation tree of the SQLConsole tab. An SQL statement for querying data in the table is automatically entered in the SQL editor. Automatically generate an SQL statement for querying data in a table
    • The Execution History tab below the SQL editor displays all historical SQL statements that were executed. You can double-click a historical SQL statement to copy the SQL statement to the SQL editor. Copy a historical SQL statement

Update data

  1. Go to the SQLConsole tab.
  2. On the SQLConsole tab, enter an SQL update statement in the SQL editor and click Execute on the top of the SQL editor.
  3. In the Execution Confirmation message, click OK.
    Execution Confirmation

Manage frequently used SQL statements

  1. Go to the SQLConsole tab.
  2. On the SQLConsole tab, enter an SQL statement in the SQL editor and select the entire statement.
  3. Move the pointer over Common SQL and select Add.
    Common SQL button
  4. In the Add to Saved SQL dialog box, enter a name for the SQL statement in the Title field, set the Scope parameter, and then click OK.
    Add to Saved SQL dialog box
  5. To insert a saved SQL statement into the SQL editor, move the pointer over Common SQL, select Select, and then select the SQL statement that you want to use. The SQL statement is automatically inserted into the SQL editor.
    Insert a saved SQL statement

View data in the form of a visual table

  1. Go to the SQLConsole tab.
  2. In the navigation tree of the SQLConsole tab, right-click the table that you want to query and select Open Table.
    Open Table
  3. On the Table tab, view the data of the table in the form of a visual table.
    View data in the form of a visual table
  4. Click the Select Columns icon in the upper-right corner. In the pop-up window, select one or more columns that you want to view and click OK. The Table tab displays only the selected columns.
    Select one or more columns to be displayed