Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to minimize all SQL stored procedures at once

My question is not quite a programming question, more along the line of how to use the software. Well, I have a file that contains all of my stored procedures for a webpage (approximately 100 stored procedures). When I open the the file I minimize the stored procedures so the file is easier to sift through. I was wondering if there was any way to minimize all of the stored procedures all at once.

I know that in Visual Studio you can highlight all of the code the press CNTRL+M+M and it will minimize all of the functions. Anything similar to this in SQL Server 2012?

Thanks.

like image 964
Chase Ernst Avatar asked Jan 29 '15 15:01

Chase Ernst


Video Answer


1 Answers

From the menu:

Edit -> Outlining -> Toggle All Outlining

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

like image 153
DavidG Avatar answered Nov 11 '22 07:11

DavidG