Query
About Querying
The querying feature is one of the core functionalities of the SQL management software, allowing users to extract the desired information from the database in a simple and intuitive manner. Through the querying feature, users can construct, execute, and optimize queries using SQL statements or visual tools.
Opening Methods
- Click on New Query in the toolbar to open.
- Right-click on Connection/Database/Data Table and select Open Console.
- Click on SQL Query in the Data View to open.
Query Designer
| Button | Description |
|---|---|
| Run | Run the SQL statement or the selected SQL statement. |
| Stop | Stop running the query. |
| Save | Save the current SQL statement. |
| Format/Beautify SQL | Beautify the current SQL statement format. |
| Compress SQL | Compress the current SQL statement format. |
| Export | Export the query results. |
SQL Editor
The SQL editor is a tool for writing and executing Structured Query Language (SQL) statements. It provides a user-friendly interface that allows users to easily create, edit, and manage data and structures in the database.
Query Results
Query results are the data sets returned after executing SQL queries.