개인 정보 보호 정책
데이터 처리 및 보안 계약
SQL Window
포커스 모드
폰트 크기
Overview
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.
The SQL window also supports the following features:
Optimize SQL formats
View SQL command execution plans
Save custom SQL as templates
View and export SQL execution results
View SQL execution history
Introduction to the SQL Window Area
No. | Region | Description |
1 | Visual Operations Panel | Table: Supports viewing all tables in the current database, including fields and indexes. Supports performing operations like adding, deleting, copying, submitting, exporting, and quick data viewing. Supports clicking the Operation button on the right side of the target table to select operations such as SQL operations, edit table structure, view table information, view table creation statement, rename, drop a table, truncate a table, and create a table with the same structure. Programmable Objects: Includes views, stored procedures, functions, triggers, and events. It supports creating, viewing, executing, and managing programmable objects. |
2 | SQL statement execution area | Input SQL statements and click Execute. It supports formatting, execution plans, and saving SQL templates as My Template. |
3 | Execution result area | Displays execution results after executing SQL statements and supports data export. Click SQL Records to view previously executed SQL statements, execution times, and results. |
4 | Quick template area | Include System Template and My Template. The preset System Template contain common SQL statements, SHOW commands, table and index operations, views, functions/stored procedures, triggers, events, permissions, and user-related SQL templates. My Template area displays user-defined SQL statements saved by the user. |
Prerequisites
Users should have query permissions for the target database or table. To request permissions, see Permission Management (Regular User). For additional operation permissions, see Managing SQL Specifications to modify the policies associated with the target database instance.
Directions
1. Log in to the DMC console.
2. In the top menu bar, click SQL Window.
3. Search for and select the database instance and library.
4. Enter an SQL statement in the execution area and click Execute.
Note
In the System Template area on the right, select a predefined SQL template, modify it as needed, and click Execute.
5. (Optional) Click Save to store the current SQL statement in My Template.
피드백