|
<< Click to Display Table of Contents >> Navigation: User Interface > Preferences > Editors - SQL Insight |
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
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 |
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. |