SQL Query

SQL queries can be issued directly on the tables.

Note

This feature is only available for premium execution environments.

How to use

1. Select the database to be connected in the left tree.
2. Click the "SQL EDITOR" button.
3. The SQL editor opens in the right pane.
4. Write the SQL query and click the "Execute" button.
5. The lower pane displays the SQL query results.

Note

• The database selected in the left tree becomes the default database. For database objects in SQL, if the database name is omitted as a prefix, the connection is made to the "default database".
• If a database name is specified as a prefix for a database object in SQL, it connects to the specified database.

Limitations

• Only Data Manipulation Language (DML) can be written in SQL.
• It is recommended that one statement be executed.
  When multiple statements are executed, the resulting object is indeterminate depending on the result of each statement.