Breakpoints

Breakpoints are temporary markers you place in your code to tell the debugger to stop your stored procedure at a given line. When you are debugging SQL stored procedures, you can set line breakpoints and variable breakpoints. Line breakpoints are saved upon termination of a debug session, however, variable breakpoints are not.

When the workbench is running a stored procedure and encounters a breakpoint, the stored procedure temporarily stops running. Execution suspends at the breakpoint before the argument is executed, at which point you can check or edit the contents of variables. You can then step over (execute) and see what effect the statement has on the argument.

With the debugger, setting breakpoints is easily accomplished via pop-up menus in the editor and Variables view. Once set, you can disable breakpoints so they do not suspend execution and then, later, enable them again.

 

Related tasks

Setting a line breakpoint
Using breakpoints
Setting a variable breakpoint