Introduction to the SQL Window
The SQL window provides users with a graphical SQL editor featuring predefined SQL templates and support for user-defined SQL execution, facilitating efficient database querying and management through an intuitive interface.
Feature Description
Add instances for quick login.
Switch between logged-in instances.
View, favorite, and manage databases and tables.
SQL execution panel.
Execute SQL commands and view results
Terminate sessions.
Optimize SQL formats
View SQL command execution plans
Save common SQL
Template SQL
Export SQL results
Generate SQL commands with SQL AI assistant, execute SQL statements, and view or export execution results.
Display real-time sessions and kill sessions.
Import and export data.
View database and table data and structure information.
View user permissions.
Region Overview
No. | Region | Feature Description |
1 | Logged-in instance display area | The top of the page displays logged-in instances, allowing users to switch between instances for SQL operations. You can click  |
2 | Database and table panel | Database Supports viewing all databases in the current instance, including tables and programmable objects. Supports clicking the Operations button on the right side of the target database to select operations such as SQL operations, database management, and creating tables, views, stored procedures, functions, events, and triggers. Table Supports viewing all tables in the current database, including column information, indexes, and triggers. Supports clicking the Operation button on the right side of the target table to select operations such as SQL operations, opening the table, editing table structure, viewing table information, viewing the table creation statement, renaming, dropping the table, truncating the table, and creating a table with the same structure. Programmable objects Includes views, stored procedures, functions, triggers, and events, supporting operations such as execution, edit, and deletion. Search for databases and tables Supports quick searches for tables, databases, and database.table entries at the top of the database and table panel. User information Supports viewing database accounts. Favorite databases and tables Click  |
3 | Execution panel | After entering an SQL statement, click Execute to perform database operations. Additional options include terminating sessions, format optimization, execution plans, clearing SQL statements, and saving the current SQL statement under My Commands. |
4 | AI panel | Supports generating SQL statements using the DMC SQL AI assistant, executing SQL statements, and viewing SQL execution results. |
5 | Execution result area | Displays execution results after executing SQL statements and supports data export. |
6 | Settings | Supports configuring query parameters, including query character set, execution timeout, maximum return rows, and query result display. |
7 | My Commands | Includes System Template and My Favorites. The pre-configured System Template provide commonly used SQL, SHOW commands, table and index operations, views, functions/stored procedures, triggers, events, permissions, and user-related SQL statement templates. User-defined saved SQL statements are displayed in the My Favorites section. |
8 | Floating tools | Supports enabling the floating tool toggle to access operations such as opening a new SQL panel, importing and exporting data, database management, real-time sessions, and creating tables, views, stored procedures, functions, events, and triggers. |
9 | Viewing permissions | Supports checking the permissions assigned to the currently logged-in account for the instance. |
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback