Execute query

Use the Execute Query window to test or run SQL statements.

Note: Only the system administrator and users with the required permissions can access these features. These features are not available in Oracle environments.

You can execute these statements:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • TRUNCATE
Note: Truncating a table removes all the data from the table and the data cannot be recovered.

You cannot execute these statements:

  • Drop database objects
  • Modify schema
  • Run statements against the DATABASEAUDIT or VIRTUALFILESYSTEM tables.

To access the Execute Query window:

  1. Select Execute Query from the Tools menu.
  2. Specify the statement you require to Test or Execute in the Query field.
  3. Use the Execute option to run the SQL script against the database.
    Note: 
    • You can use the Test option to only test the SQL without modifying the data.
    • If you have executed a SELECT statement, the results are displayed below the Query window.