Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Validate Syntax

Validate Syntax

Prior to executing SQL statements you can:

Check SQL syntax (checks whether the syntax is valid without executing)
Verify SQL (checks whether the syntax is valid, executes the code, and then undoes any changes to the code object and data)

To check SQL syntax

Select the block of code in the Editor, and click

To verify SQL

Select the block of code in the Editor, and click

Caution When possible, Toad undoes any changes to the object and data in the database after executing the script (notice that the Result Sets tab is empty). However, Verify SQL cannot rollback statements that use implicit commits, such as CREATE table and DROP database. For those statements, the object remains/is removed from the database when you verify the SQL statement.