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.
Query data
- Go to the SQLConsole tab.
- On the SQLConsole tab, enter an SQL query statement in the SQL editor and click Execute on the top of the SQL editor.
Update data
- Go to the SQLConsole tab.
- On the SQLConsole tab, enter an SQL update statement in the SQL editor and click Execute on the top of the SQL editor.
- In the Execution Confirmation message, click OK.
Manage frequently used SQL statements
- Go to the SQLConsole tab.
- On the SQLConsole tab, enter an SQL statement in the SQL editor and select the entire statement.
- Move the pointer over and select Add.
- 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.
- To insert a saved SQL statement into the SQL editor, move the pointer over , select Select, and then select the SQL statement that you want to use. The SQL statement is automatically
inserted into the SQL editor.
View data in the form of a visual table
- Go to the SQLConsole tab.
- In the navigation tree of the SQLConsole tab, right-click the table that you want to query and select Open Table.
- On the Table tab, view the data of the table in the form of a visual table.
- 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.