Overview
This tool allow to test existing queries used by the solution or create new ones.
It's also used to preview the results, and to customize the right DataGrid settings for visualization. The "SQL Query Builder" is designed to facilitate the construction and execution of SQL queries. This tool interfaces with selected databases and allows for intricate query development and data management within a development or production environment.
On this page:
Table of Contents | ||||
---|---|---|---|---|
|
User Interface
Database Selection
This section provides options to select the target database for query execution.
Users can choose between a database used in the project, solution or establish a custom database connection. This flexibility ensures that queries can be tailored to specific data stores. Allows users to select the context in which they are operating. This enables the execution of queries in different environments
It is not necessary to execute any Connect command. Once the Query is executed, the connection with the Database is automatically executed.
Query Input and Execution
This code editor area where users can write or paste their SQL queries.
A dropdown menu offers a selection from predefined datasets or queries. Write the SQL query (or use the arrow icon to bring from the solution) and press 'Execute Query' for start.
Result ManagementResults DataGrid
Display the outcomes outcome of the executed queriesquery. It includes functionality to group results by dragging and dropping column headers, and most of features described in the page Working with DataGrids.
Output and SearchResults search
At the bottom section for system messages and execution logs. Its top-right side of the DataGrid, It's possible make a quick search of the displayed results of the querys started with the 'Find Results' button.
In this section
...:
Page Tree | ||||
---|---|---|---|---|
|