SQL Console

Area

Section

Description

Left-side resource tree

Visual operation section

Manage your database visually.

• Table

  You can view all tables in the current database, including their columns, column types, and indexes. You can also right-click a table to edit its structure, manage it, export or import data, and perform batch operations.

• Programmable Object

  Create, view, execute, and manage Programmable Objects, such as views, stored procedures, functions, triggers, and events.

  Note

  The console displays up to 1,000 entries.

• key-value pair information

  Note

  DMS displays this information for NoSQL databases.

Top toolbar

Extended features section

The following features are available:

• (Apply for data owner/Change control): Click this icon to apply to be a data owner or to configure DDL, DML, and SELECT change permissions for the target database.

• (Table List): Click this icon to switch to the Table List page, and click the icon to return to the Query page.

• (Data Analysis): Click this icon to create a data analysis ticket. For more information, see One-click data warehousing.

  Note

  This icon is displayed only for ApsaraDB RDS for MySQL databases.

• (Database Analysis): Provides database autonomy services such as one-click diagnostics, real-time performance, instance sessions, and space analysis through Database Autonomy Service (DAS). You are redirected to the DAS console. For more information, see Real-time Performance and Instance Session.

• (Sync Metadata): After you click this button, DMS collects the latest metadata from the database, such as tables, columns, indexes, and Programmable Objects. This enables hierarchical permission control for tables, columns, and Programmable Objects. For more information, see metadata.

• (Export): Use the export feature to export a database, its table structure, or table creation statements. You can also access the Manage Table Structure Versions page.

• (operation audit): The operation audit feature saves all data query and change records. You can query details like the operation, the user, and the time of the operation. For more information, see operation audit.

  The risk audit feature collects and assesses various risks associated with database usage. For more information, see Risk audit report.

• (Share): Use this feature to share the console and commands for this database with relevant personnel. For more information, see Share an SQL Console.

• (Super SQL Mode): After you enable Super SQL Mode, administrators and DBAs can execute SQL statements in the SQL Console without being restricted by security rules. For more information, see Super SQL Mode.

SQL editor pane

Command execution section

Enter an SQL statement and click Execute to perform operations on the database. Other features are also available, such as Format, execution plan, and Settings.

• Execute: Click Execute to run the SQL statement you entered.

• Format: Click Format to optimize the format of your SQL statement.

  For example, if you enter SELECT * FROM `test_table`; and click Format, the SQL statement is formatted as follows:

  SELECT
    *
  FROM
    `test_table`;

• Execution plan: View the execution plan for the SQL statement you entered.

Bottom log pane

Execution results section

After you execute an SQL statement, you can view the results. You can also view row details, add rows, delete rows, and submit changes.