Running SQL statements


This SQL shell feature allows SQL statements on the database. To use this feature, you must be connected to a database. (See ODBC Connection or JDBC Connection)
Then, from the Tools menu choose SQL Shell. Enter the SQL statement and press Enter.

There are three options:
  1. Close all result: clears the information under the Result tabs. The information under the Output tab is kept.
  2. Clear output: clears the information under the Output tab. The information under the Result tabs is kept.
  3. Execute files: allows you to get an SQL file and to run it.