How to minimize all SQL stored procedures at the same time

My question is not really a programming issue, but more about how to use the software. Well, I have a file containing all my stored procedures for a web page (about 100 stored procedures). When I open the file, I minimize the stored procedures, so the file is easier to sift. I was wondering if there is a way to minimize all stored procedures at once.

I know that in Visual Studio you can highlight all the code by pressing CNTRL + M + M, and this will minimize all functions. Anything like that in SQL Server 2012?

Thanks.

+5
source share
2 answers

On the menu:

Edit β†’ Outlining β†’ Toggle All Outlining

To create your own keyboard shortcut, again from the Tools β†’ Options β†’ Environment β†’ Keyboard menu, select the Edit.ToggleAllOutlining command and create a new shortcut of your choice in the Global or SQL Query editor .

+7
source

Resets all selected regions to display only the outermost groups in the CTRL + M, CTRL + A hierarchy

Found here: https://msdn.microsoft.com/en-us/library/ms174205.aspx

+2
source

Source: https://habr.com/ru/post/1212206/


All Articles