1.3. Manage view

The former widget known as SQL Tool received so many improvements that it was needed to be moved from the design view to its own dedicated space on the main window. It will be fully detailed in the advanced tools chapter, nevertheless, it'll be quickly described here in this section. This view contains only three subsections (as shown in the image below) and they are:

  1. Database explorer: this section enables the user to select previously configured connections in order to explore available databases as well the objects within them. This control is not basically for read-only operations. It is possible to drop or rename objects, modify table data, truncate tables, visualize object's attributes, and much more.

  2. SQL execution: enables the user to issue commands to the currently browsed database. Any SQL command can be executed in this field and the results are exposed at the bottom of the section. Additionally, is possible to load SQL scripts, export results of commands to external files, save the current commands to external files, and many others.

  3. Source code: enables the user to quickly visualize the source code of the objects selected in the database explorer.

Feb 17, 2021 at 11:45