A new feature in SQL Server Management Studio 2008 is 'outlining' (the ability to collapse regions). It is awesome. However, by default all regions are expanded. I can't seem to find a way to 'collapse all' (also called 'toggle outline' in Visual Studio). Is anyone aware of a way to do this? I've been tasked with reviewing a 3,000 line stored procedure, and collapsing regions one-by-one is cumbersome.
You can click the minus sign on the SELECT * line to collapse just that SELECT statement. To collapse the whole BEGIN - END block, click the minus sign on the BEGIN line.
The following collapse functions take two input sequences, left and right, and produce the result sequence of type double where the computed scalar result is the first element. The two input sequences must be of the same type.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With