verify-queries-visual-database-tools.md

title	Verify Queries
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdtsql.chm:100644
helpviewer_keywords	verifying queries queries [SQL Server], verifying checking queries
ms.assetid	1382c0c0-46dc-45f9-ab38-9bba1d347eea
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Verify Queries (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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.

Some notes to keep in mind about verifying queries:

• A statement can be valid, and therefore be verified successfully, even if it cannot 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 will detect the error when you run the query.

• Queries that contain parameters cannot be verified.

To verify an SQL statement

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

See Also

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