Query Builder Options
Go Up to Configuring Feature Options
The Options Editor’s Query Builder Options tab lets you specify operational and execution preferences for the Query Builder. Option parameters set on the Options Editor elicit a prompt if there are different options set on an open individual session. Global options override properties set within individual Query Builder sessions.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the Query Builder, see Query Builder.
The table below describes the options and functionality on the Query Builder tab:
| Interface Element | Option | Description | Default |
|---|---|---|---|
|
Code Generation |
Generate Use Database statement |
Adds a line of SQL code indicating which database or instance is used in the statement. |
Selected |
|
Generate owner names |
Adds a line of SQL code showing the table owner name as part of the query. |
Selected | |
|
Include Row Count limits |
Includes the output row limit set in the Execution settings. |
Not selected | |
|
Generate SQL/92 if supported by DBMS |
SQL/92 is a standard for relational database management systems. |
Not selected | |
|
Execution |
To set the maximum number of rows in your result set, type the number in the dialog. This lessens congestion of server processes when queries execute by setting row count limits. |
1000 rows | |
|
General |
Show Column Data types in Query Diagram |
Reveals the data type in each column for tables in the SQL Diagram pane. |
Not selected |
|
Confirm on Item delete |
Opens a Confirm Delete dialog when an item is deleted. |
Selected | |
|
Auto Populate Views |
Checks syntax every time an execute statement, refresh or copy statement begins. |
Not Selected | |
|
Auto Format |
Automatically sets style and spacing of display. |
Selected | |
|
Auto Join |
Run Automatically |
Automatically detects names and data types, and create joins for multiple tables. |
Selected |
|
Require Indexes |
Joins only indexed columns. Requires an indexed column for joins. |
Selected | |
|
Require same data type |
Automatically joins columns with the same data type. |
Selected | |
|
Syntax Checker |
Automatic Syntax Check |
Automatically checks SELECT and CREATE VIEW statements for errors. |
Selected |
|
Warn on non index join |
Returns a warning when it detects a join against a non-indexed column, or a column not participating in a primary key |
Not selected | |
|
Display |
Lets you sets the style, size, and color of Column Font and Title Font. Also lets you set the background Table Color for the SQL Diagram Pane. |
Available | |