Verifying a Query

To avoid problems, you can check the query you have built to ensure its syntax is correct. This option is especially useful when you enter statements in the SQL pane.

Note   A statement can be valid, and therefore be verified successfully, even if it cannot be represented in the Diagram and Grid panes.

To verify an SQL statement

• Right-click in the SQL pane, and select Verify SQL Syntax from the shortcut menu.