collapse blocks to definitions
hi, I work with MS SQL Managemenet System and a lot of *.sql files for updating databases
to my specific file can have a lot of lines of code (up to 1000 lines) and navigation and reading becomes tragic - I always manually collapse (press on [-] next to block name) all blocks like CREATE PROCEDURE, CREATE FUNCTION
I really love your SQL Document Outline feature
so you can handle another feature 'Collapse all blocks to definition' and simplify the life of a lot of db coders
Will be glad to be among your clients
Thank you and good luck, guys
Best regards,
Aleksey Baryshnikov
![](https://secure.gravatar.com/avatar/d12f2e871d34bb7540d4d3588be0a4fd?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Sheldon commented
Good idea. I guess the difficulty I have with the outline is it doesn't give a snippet of the code or allow a "section comment", so all i have is a bunch of selects or begin/end in the outline, which isn't terribly descriptive.
-
Rolf Wyss commented
this excactly what I look for:
I work much with large procedures and in there I have a lot of nested BEGIN END and IF END IF statements. It's sometimes not easy to keep the overview. A helpful feature would be to fade out or fade in code groups like BEGIN END and/or IF END IF. In some situation you already have this but only on the highest level (stored procedures first BEGIN). -
Aleksey Baryshnikov commented
that would be also sweet if I received the url of just created idea to email
so that I could look at it from time to time and read comments