Code Collapse and Expand Feature in SQL Server Management Studio 2008

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Chris Jenkins — Mon, 18 Feb 2013 14:39:25 GMT

Thank you for the tip (on how to turn this *off*)!

Coming from the SQL200 world, I'm not quite ready for this feature yet...

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Desiree — Wed, 21 Nov 2012 01:25:15 GMT

Can't tell you how many times I've gone to select a line or lines of code and accidentally collapsed a bunch. Not a huge deal but I'm so glad to have an out! THANK YOU!

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

shree — Thu, 25 Oct 2012 17:08:18 GMT

was it taken out in r2?

it seems to show outlines when i open my sql fileon SQL 2008 server's query window but doesnt on my R2 machine's window

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Joseph B — Thu, 27 Sep 2012 14:26:23 GMT

It would be nice to be able to collapse / expand these code blocks via keyboard shortcuts... Visual Studio does it, I believe is Ctrl-M-M, Ctrl-M-L and Ctrl-M-O.

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Srinika — Fri, 18 May 2012 18:39:23 GMT

I have SSMS 2008 R2

DB Server is SQL Server 2008.

I have "Outline Statements" checked.

but I do not have this feature.

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Aparichit — Mon, 11 Apr 2011 06:40:26 GMT

Please vote up for the bug "Plus (+) and minus (-) sign on left of editor which is used to Collapse/Expand Code Blocks disappears when SQLCMD Mode is enabled in SQL Server Management Studio"

connect.microsoft.com/.../plus-and-minus-sign-on-left-of-editor-which-is-used-to-collapse-expand-code-blocks-disappears-when-sqlcmd-mode-is-enabled-in-sql-server-management-studio

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Kristi — Wed, 21 Jul 2010 02:00:49 GMT

Nice...

thx for the information..

but in my SSMS..

this feature only work at all comments, so i can use this to collapse n expand my own script (begin end, long select code etc...)

can u give any tips so i can use this feature for my script??

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

pelley — Mon, 03 Aug 2009 17:11:17 GMT

Nice feature... I use it all the time! I think they called it outlining because Visual Studio also uses that terminology already for the same feature.

re: Code Collapse and Expand Feature in SQL Server Management Studio 2008

Brian Tkatch — Fri, 31 Jul 2009 15:41:44 GMT

There's an adding for 2005 that adds collapse: http://www.ssmstoolspack.com/

Nifty toolpack it is.