SQL Prompt - 5.3

SQL Prompt

Summarizing a script - SQL Prompt

SQL Prompt allows you to view a summary of the actions that a SQL script performs, in the order in which they occur.

Note: Summarizing a script is available only in SQL Prompt Pro Edition.

To view the script summary:

  1. Open the script you want to summarize in a query window.
  2. On the SQL Prompt menu, click Summarize Script.

    The Summarize Script dialog box is displayed:

    SQL Prompt 5.0 Help Linked GIF File Template

The script is displayed in grouped blocks of SQL. For example, the keywords within a CREATE statement are grouped into a block. To expand a block, click or double-click the keyword.

The following symbols are used to draw your attention to commands that change the context:

USE commands

SETUSER, EXECUTE AS LOGIN, and REVERT commands

You can click any keyword in the summary to highlight it in your query editor:

SQL Prompt 5.0 Help Linked GIF File Template

If you click on the main keyword for a block, the block is highlighted.

To more easily view the script in your query editor as you navigate the summary, it can be useful to move the Summarize Script dialog box onto another monitor. Alternatively, you can resize the dialog box as required.

Was this article helpful?

Search support
Forums
Visit the SQL Prompt forum.
Learning SQL Prompt
Knowledge base

SQL Prompt

all SQL products

all products

Notes & articles

SQL Prompt

all SQL products

all products

Demos & walkthroughs

SQL Prompt