title	Toggle a Breakpoint
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).
titleSuffix	T-SQL debugger
ms.prod	sql
ms.technology	ssms
ms.topic	conceptual
ms.assetid	c477ab89-a1cd-4f2c-aa7c-40525041100f
author	markingmyname
ms.author	maghan
ms.reviewer
ms.custom	seo-lt-2019
ms.date	03/14/2017
monikerRange	>=aps-pdw-2016\|\|=azuresqldb-current\|\|=azure-sqldw-latest\|\|>=sql-server-2016\|\|>=sql-server-linux-2017\|\|=azuresqldb-mi-current

Toggle a Breakpoint

[!INCLUDE SQL Server]

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

[!INCLUDEssms-old-versions]

Breakpoints

Once the breakpoint has been set, it is represented by an icon in the grey bar to the left of the statement. The icon is called a breakpoint glyph. [!INCLUDEtsql] breakpoints are applied to a complete [!INCLUDEtsql] statement. When a breakpoint is toggled on, the debugger highlights the associated [!INCLUDEtsql] statement.

If there are multiple [!INCLUDEtsql] statements on a line, you can toggle a breakpoint for each statement. Clicking in the grey 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 clicking Toggle Breakpoint on the Debug menu. If you have multiple breakpoints on a line, there is only one breakpoint glyph in the grey bar on the left.

After a breakpoint has been 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.