This isn't a shortcut key, but there is a menu option in the Query Editor to do this. Open your query and then go to Edit > Outlining > Toggle All Outlining. This will toggle (i.e. expand/collapse) all nodes in the query.

Jul 19, 2018 · For some years now, SQL Server Management Studio (SSMS) has had the ability to use code outlining, the same way that other Visual Studio applications can. This can be very useful when you are trying to navigate around a large script file. The simplest usage is to collapse or expand a region of code.

Feb 13, 2025 · You can use the outlining feature in the SQL Server Management Studio query editors to selectively hide code when you edit queries. This enables you to more easily view the code you're working on, especially in large query files.

Mar 28, 2021 · The feature you are looking for doesn't exist but you can achieve this using the menu option in the Query Editor. Open your query and then go to Edit > Outlining > Toggle All Outlining : this will expand/collapse all the nodes in your query.

Aug 13, 2018 · I have an intermittent problem with SSMS. Sometimes (as I write this, actually), code outlining is gone in my SSMS. That means there are no + and - signs to expand/collapse sections of code.

Mar 11, 2017 · One way to quickly select blocks of code within SSMS is to minimize the code using the -button next to the leading keyword in a SQL statement (e.g. SELECT, UPDATE, DELETE, WITH, etc.) then highlight that line and press F5 to execute it.

Apr 11, 2024 · Learn how to use the code outlining feature in the SQL Server Management Studio query editors to selectively hide code.

Jan 22, 2018 · SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with large query files. In the following screen shot, the indicated box is what you click to show / hide the selected region.

In SSMS 18.x and 19.x, the outlining feature that allows you to collapse SQL code often stops working, i.e. the +/- next to the code disappears and neither shortcuts or clicking in the menu will collapse code.

Feb 13, 2009 · SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with large query files. In the following screen shot, the indicated box...