1.3. Manage view

The former widget known as SQL Tool received so many improvements that was moved from the design view to its own space and will be fully detailed in the advanced tools chapter, nevertheless, it'll be quickly described here in this section. This view contains only two 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's data, trucante 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 file, save the current commands to file and many others.

Jan 3, 2020 at 12:33