It is possible to view data from a table like this:
ServicesWindow, select a database connection
View datato display table values
To create a new SQL file from an hEIDI project, select the
File > New File menu, then choose
SQL File under the
Specify a name and a project folder then
Finish. An empty SQL file appears on the screen.
Select your database in the droplist at the top.
When you query is written, you can execute it using the
Run SQL icon:
If you have several queries in your file, you can select one to execute, then right-click on it and choose
If your query executed successfully, the result will display in a table.
If needed, see how to export an SQL result to a file.