Data Management (DMS) provides the SQLConsole for you to execute SQL statements with ease. You can use this feature to add, delete, modify, or query data in a database in a visualized manner when data query or development is involved.
Prerequisites
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.
GUI of the SQLConsole

No. | Section | Description |
---|---|---|
1 | Visual operation section | In this section, you can manage your database in a visualized manner.
|
2 | Extended feature section | In this section, shortcuts to extended features are provided. You can use these features
by clicking the following icons:
|
3 | Command running section | In this section, you can write and execute SQL statements to manage the current database.
You can also format SQL statements, create execution plans, save commonly used SQL
statements, and configure display settings.
Note You can click the
![]() |
4 | Execution result section | In this section, you can view the execution results after SQL statements are executed.
You can also view the details about a single row and add, delete, or modify data.
Note You can click the Execution History tab to view the historical execution records. For example, you can view the time
at which the execution of an SQL statement started, the affected database, and the
details about the SQL statement. You can also export the execution results as required.
|
Procedure
Usage notes
- A table may contain sensitive or confidential fields. You do not have permissions
to access these fields. Therefore, the values of these fields are displayed as
******
in the query results. For more information, see Manage sensitive data. - By default, a maximum of 200 data rows can be returned for each query. If you are
a DMS administrator, you can change this value as needed. To change this value, perform
the following steps: In the top navigation bar of the DMS console, click Security and Specifications. On the page that appears, click in the left-side navigation pane.
Note If you use the previous version of the DMS console, move the pointer over the More icon and choose .
- A full scan can be performed on a table that does not exceed 10 GB in size. If you are a DMS administrator, you can change this value as needed. To change this value, perform the following steps: In the top navigation bar of the DMS console, click Security and Specifications. On the page that appears, click in the left-side navigation pane.
- By default, the timeout period to execute a single SQL statement is 60 seconds. If you are a DMS administrator, you can change this value as needed. To change this value, perform the following steps: Move the pointer over the More icon and choose Data Assets > More in the Actions column of the database instance that you want to manage and select Edit. In the Edit dialog box, change the value in the Advanced Information section. . On the Instance List tab, move the pointer over