T-SQL Script Summary

Using the Script Summary you can view a short summary of any of the the batches and the statements in
the current T-SQL script.

View the script summary

1. Open the script in a SQL Server Management Studio query editor or in Visual Studio 2005 text editor

2. Use the Script Summary… command on the SQL Enlight menu.

The script summary will be displayed in a toolbox window.

3. You can uncheck the Don’t show batch nodes option to include the batches in the script summary.

Batches are not by default shown in the summary.

summary-1

The Script Summary is hierarchically structured. All statements in it are grouped in batches. All batches and statements that contain nested statements can be expanded.

When you select a statement or a batch it is highlighted in the text editor along with all of its nested statements.