Online Documentation for SQL Manager for SQL server
Design Query
Design Query is implemented in SQL Manager for SQL Server for building queries visually. The tool allows you to create and edit queries without deep knowledge of SQL. You can also prepare and execute queries, and view the results of their execution.
To open Design Query, select the Tools | Design Query main menu item or use the corresponding toolbar button.
- Using Navigation bar and Toolbar
- Working with diagram area
- Joining two database objects by columns
- Setting the selection criteria
- Setting output columns for selection
- Setting the grouping criteria
- Setting parameters of sorting
- Working with editor area
- Executing queries and viewing results
- Viewing query plan
Availability: |
|
Full version (for Windows) |
Yes |
Lite version (for Windows) |
No |
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
See also: |