Verify queries (Visual Database Tools)

Applies to: SQL Server

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 (Visual Database Tools).

When you verify queries, keep in mind:

• A statement can be valid, and therefore be verified successfully, even if it can't be represented in the Diagram Pane and Criteria Pane.

• SQL Verification can detect some, but not all SQL errors. If a query contains an error not detected during SQL verification, the database detects the error when you run the query.

• Queries that contain parameters can't be verified.

Verify a SQL statement

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

Related content

• Run queries (Visual Database Tools)
• Perform Basic Operations with Queries (Visual Database Tools)