The autocompletion-feature of the "DatabaseExplorer" has some special features which can help you to write your sql-queries fast and easy.
For Example:
The autocompletion table only shows tables that are really dependent in the previously known sql-query.
That means all tables dependencies, which are known before your caret-position, will be considered for your choice to shrink it to only the table which are really connectable together.
If you have no dependency inside your database between a table and another, but inside a program exists a logical dependency, you are able to set a manual-foreignkey which will be handled like a normal one for autocompletion.
Special Hint:
This feature required to load the complete database-structure in the TreeView on the left side of the application to know all dependencies.
This is only needed once if the database is not edited in the background, otherwise you need to reload new or changed tables.
But don't worry!
The DatabaseExplorer caches all loaded database and table information persistently to be ready when you start the application again!
Another feature is that the join will be automatically constructed for you.
The alias names will be also generated automatically and already existing aliases will be used.
