About dbForge Query Builder for SQL Server

Build complex SQL queries visually.

dbForge Query Builder for SQL Server is an extended data management solution that lets you quickly and effortlessly create complex queries.  dbForge Query Builder for SQL Server’s main component is a visual diagram where you can "draw" your query. Adding tables, creating joins, or editing conditions is very simple and can be done with a few clicks of the mouse. With dbForge Query Builder for SQL Server you can effortlessly group, sort and filter data. Plus you can benefit from cached updates and manage your data based on your needs.

dbForge Query Builder for SQL Server Key Features

  • Visual query creation
  • State-of-art diagram with zooming
  • Query schema window for complex queries
  • Undo/Redo support
  • Visual editing of sub-queries
  • Convenient expression builder
  • SQL editor with syntax coloring, bookmarks, and text search
  • Extended SQL formatting in the editor
  • Automatic SQL syntax check
  • Advanced management of query results
  • Diagram and data printing
  • Data editor with filtering, grouping, and sorting options
  • Customizable and intuitive GUI
  • One-click help system

Advanced diagram for visual query creation - Save your time and avoid errors, while creating queries. Cancel monotonous coding and start “drawing” your query on the elaborated diagram. Drag’n’drop required tables to the diagram, join them, and select columns visually. For a better view, use zooming options.

Simple creation of sub–queries – Easily create complex sub–queries. Manage them as a simple query. Using the tabbed window, you can edit sub–queries in separate windows and easily access the main query.

Convenient expression editor - Automate your work with query criteria. See and visually edit them on separate tabs under the diagram. You don't need to type column names or remember complex rules. Just select required data from the lists and enjoy the results.

Extended data management - Effortlessly group, sort, and filter data in the grid. For better data view and editing, use various modes. Benefit from cached updates and manage your data based on your needs. Moreover, you can print query results.

Intuitive and Highly Customizable UI - You can tune the layout and work on–the–fly. GUI elements are well–located and easy–to–use. Tabbed documents, dockable tool windows, and other customizable elements will give you a quick navigation and full control.