You can execute various types of SQL statements on the SQL Console page of the Data Management (DMS) console. On this page, you can also add, remove, modify, and query data in a database instance in a visualized manner. The SQL Console page is designed for scenarios such as data query and data development.
You are granted the query permissions on the database or table that you want to query. For more information about how to apply for the permissions, see Overview.
GUI of the SQL Console page
|1||Visual operation section||In this section, you can manage your database instance in a visualized manner.
|2||Extended feature section||This section provides the following icons:
|3||Statement execution section||In this section, you can write and execute SQL statements to manage the current database instance. You can also format SQL statements,
create execution plans, save frequently used SQL statements, and configure display
Note You can click the icon in the upper-right corner of the section to add multiple SQLConsole tabs.
|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, remove, 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 an SQL statement starts to execute, the affected database instance, and the details about the SQL statement. You can also export the execution results as required.
- Log on to the DMS console V5.0.
- In the top navigation bar, choose .
- In the Please select the database first dialog box, enter a keyword to search for the database that you want to manage, select the database from the search results, and then click Confirm.
- On the SQLConsole tab, enter the SQL statements that you want to execute and click Execute.
- A table may contain sensitive or confidential fields, and you may not have permissions
to access these fields. In this case, the values of these fields are displayed as
******in the query results. For more information, see Manage sensitive data.
- By default, up to 200 rows of data can be returned for each query. If you are a DMS administrator, you can change this value as required. To go to the page on which you can change this value, perform the following steps: In the top navigation bar of the DMS console, move the pointer over Security Rules. and click
- By default, 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 required. To go to the page on which you can change this value, perform the following steps: In the top navigation bar of the DMS console, move the pointer over Security Rules. and click
- By default, the timeout period for executing a single SQL statement is 60 seconds. If you are a DMS administrator, you can change this value as required. To change this value, perform the following steps: In the top navigation bar, move the pointer over Data Assets and click More in the Actions column, and then select Edit. In the Edit dialog box, change the query timeout(s) parameter in the Advanced Information section. . On the Instance List tab, find the database instance that you want to manage, move the pointer over