EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Query Builder

General options


CheckBox Allow SELECT queries only

When this option is checked, the INSERT, UPDATE and DELETE statements are not allowed in Query Builder.


CheckBox Select condition row

Displays the selected condition in different rows on the Criteria and Grouping Criteria tabs of Query Builder.


CheckBox Drag field name

Displays the dragged field name in the Builder area.


CheckBox Hide selection when inactive

Hides the selection when the Query Builder window is inactive.


CheckBox Show field types

Displays the field data type next to the field name in the table box.


CheckBox Union all by default

Check this option to use the UNION ALL expression in Query Builder by default.

The UNION keyword allows you to include the results of two SELECT statements in one resulting table.

The ALL parameter incorporates all rows into the results, including duplicates. If not specified, duplicate rows are removed.


CheckBox Allow owner prefix for dbo objects

Adds the schema name to the table name in the 'Table' box caption (for [dbo] schema objects)


CheckBox Show actual execution plan on query execution

If this option is checked, the query plan is displayed within the corresponding tab of the Query Builder window.


Environment Options - Tools - Query Builder



Visible tabs

These options specify which Query Builder tabs are available and which are not. Use the check boxes to make the corresponding tabs visible/invisible.


Script format

These options specify case formatting of keywords and functions in query text within the Edit tab: As is keeps the original case, Uppercase sets all the keywords/functions to the upper case, Lowercase sets all the keywords/functions to the lower case, and First upper sets the first letters of all keywords/functions to the upper case.



Additionally, you can set styles and color for all Query Builder objects by using Style & Color Palette.



See also:

Visual Query Builder