SQL Scratchpad

The SQL Scratchpad can be used to quickly experiment with creating your SQL statement.  It allows you to parse and execute any SQL SELECT statement against the currently selected view.

Execute

Executes the SQL statement against the currently selected view.  The output of the SQL statement will be displayed in one of the Results tabs. If the SQL statement cannot be executed the reason for the failure will be displayed in the Text Results tab.

Parse

Parses the provided SQL statement. Parsing a SQL statement is a quick way to detect syntax errors without the overhead of full statement execution.

SQL Statement

The SQL Select statement to be executed.

Results

SQL execution results will be displayed in one of the results tabs. The table results tab displays execution results in a table format. The text results tab displays execution results in a text-only format.

Row Count

The row count at the bottom of the window displays the number of results retrieved by the SQL statement.