Editors - SQL Insight

Previous  Index  Next  How To Use

In each Code Editor, there's SQL & Parameter Insight (read the topic for a detailed description), you can edit the settings here.

 

SQL & Parameter Insight Settings (click to expand)

 

SQL Insight

Use SQL Insight in code editors

(No automatic SQL Insight in the Script Editor)

Check this to turn ON the use of SQL Insight, optionally turn OFF the SQL Insight in the Script Editor.

Include system tables and/or views

Include system objects in the list of available tables and views, available for InterBase & Firebird.

Disable timer, force only

Disable automatic pop-up of the SQL Insight list, the user has to force it using the keyboard.

Delay

Adjust the delay for the automatic pop-up.

Sort order

When using a DBMS with schemas, the objects can be order by object name, or by qualified name (includes schema name), eg:

 

sort by qualified name:

ASchema.NewObject

BSchema.ANewObject

 

sort by object name:

BSchema.ANewObject

ASchema.NewObject

 

This does not affect filtering.

Schema name

This affects if the schema name is included in inserting the object name.

 

Possible options are:

1.Never: only insert the object name, ignore the schema
2.Always: always use the fully qualified name
3.Not for single schema: do not insert a schema name if you have filtered the Database Navigator to hold only a single schema
4.Only for non default schema: only insert a schema name if the object is from a different schema than your default schema

 

Parameter Insight

Use Parameter Insight in code editors

(SQL Functions only)

Check this to turn ON the use of Parameter Insight, optionally use SQL functions only and avoid fetching metadata information for Stored Procedures and Stored Functions.

 

Disable timer, force only

 

Disable automatic pop-up of the SQL Insight list, the user has to force it using the keyboard.

 

Delay

Adjust the delay for the automatic pop-up.