It analyses SQL query code snippets you are writing and offers only appropriate database object names and syntax for their completion
(see
examples below).
In order this ability to work, you should be connected to your databases.
To add new connection:
-
Switch to SQL control
-
Press Add new connection button
-
The following dialogue will appear:
Fill out all fields with appropriate values and press Ok:
-
If the Application succeeded to connect to your database, all database objects (tables with fields) will be displayed in the SQL control. Otherwise, you'll
get error message. These objects and SQL structures form completion list.
SQL toolbar:
With SQL toolbar you can add/remove new connection, connect/disconnect to/from it, view and change your connections properties.
These operations are also accessible from mouse right click menu:
Examples:
SQL keywords autocomplete:
SQL tables autocomplete:
SQL table's fields autocomplete: