Working with gSQL
gSQL is a graphical SQL tool for editing query strings, running SQL statements and scripts, and printing SQL statement execution plans.
The main functions of gSQL are:
- Load: load a SQL file in text format.
- Save: save the query strings shown in the gSQL editor as a text file.
- Execute: Execute multiple queries and get the results in text format.
- Select: Issue a Select statement, get the results in table format, and save them in an Excel file.
- Plan: Get the plan of a Select statement in tree format.
- Clear: Erase all of the text in an active gSQL editor.
- SQL History: Show previously issued SQL statements. They can be copied and executed again.
Structure
A single gSQL pane consists of an editor and a result view, which have the same title, as seen below. Closing the gSQL editor closes both of them.
Open/Close
When connected to a database, gSQL opens automatically. Additional instances of gSQL can be started by executing "Open gSQL" in the context menu of the target database.