|Previous Index Next How To Use|
Database Workbench has two "insight" tools, one is called SQL Insight and one is called Parameter Insight, both can help you with writing SQL statements.
The SQL Insight tool allows you to quickly write SQL statements by selecting items from the pop-up list, see main topic SQL Insight.
Example on an SQL JOIN
When writing SQL joins and when you have referential constraints in your database, SQL Insight will allow you to select the reference, the SQL Insight tool will automatically write the JOIN condition for you.
Additionally, SQL Insight can help you to select columns from tables in SELECT, WHERE, ORDER BY and other clauses.
The Parameter Insight tool aids in writing calls to SQL-functions or user written Stored Procedures and Functions. It displays a pop-up hint with parameter names and data types.
Parameter Insight examples
In the case of multiple parameters, entering the parameter separator (usually a "," character), the current parameter you need to enter is displayed in a bold font style in the pop-up hint.
The Parameter Insight tool can be customized in the Preferences.