Toggle a Breakpoint

THIS TOPIC APPLIES TO: yesSQL ServeryesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

The act of setting a breakpoint on a Transact-SQL statement is called toggling a breakpoint.


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. Transact-SQL breakpoints are applied to a complete Transact-SQL statement. When a breakpoint is toggled on, the debugger highlights the associated Transact-SQL statement.

If there are multiple Transact-SQL 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.

Toggle a Breakpoint

To toggle a breakpoint on a Transact-SQL statement

  1. Click the gray bar to the left side of the Transact-SQL 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, click Toggle Breakpoint.