Skip to content

Latest commit

 

History

History
36 lines (24 loc) · 2.13 KB

File metadata and controls

36 lines (24 loc) · 2.13 KB
title Toggle a Breakpoint
titleSuffix T-SQL debugger
description Learn how to toggle a breakpoint to highlight the associated Transact-SQL statement, and to perform various actions on the statement (such as editing).
author dzsquared
ms.author drskwier
ms.reviewer randolphwest
ms.date 09/09/2025
ms.service sql
ms.subservice ssdt
ms.topic how-to

Toggle a breakpoint

[!INCLUDE SQL Server]

The act of setting a breakpoint on a [!INCLUDE tsql] statement is called toggling a breakpoint.

Breakpoints

Once the breakpoint is set, it's represented by an icon in the gray bar to the left of the statement. The icon is called a breakpoint glyph. [!INCLUDE tsql] breakpoints are applied to a complete [!INCLUDE tsql] statement. When a breakpoint is toggled on, the debugger highlights the associated [!INCLUDE tsql] statement.

If there are multiple [!INCLUDE tsql] statements on a line, you can toggle a breakpoint for each statement. Selecting the gray bar on the left of the window toggles a breakpoint on the first statement on the line. You can toggle a breakpoint in a subsequent statement by highlighting any part of the statement, or moving the cursor into the statement, and then either pressing F9 or selecting Toggle Breakpoint on the Debug menu. If you have multiple breakpoints on a line, there's only one breakpoint glyph in the gray bar on the left.

After a breakpoint is toggled, you can perform various actions on the breakpoint, such as editing its properties or temporarily disabling it. For more information, see Transact-SQL breakpoints.

Toggle a breakpoint on a Transact-SQL statement

  1. Select the gray bar to the left side of the [!INCLUDE tsql] statement.

  2. Alternatively, either highlight any part of the statement or move the cursor to the statement, and then perform either action:

    • Press F9.

    • On the Debug menu, select Toggle Breakpoint.