Post reply

How to save collapse sections of the query window and save it like that

  • May 21, 2019 at 5:47 pm

    #3645830

    Hi,

    My manager would like it that when he collapses certain parts of the query and saves it, it will open that way; and not have it all expanded.

    Is there a way to do this?

    Thank you

  • May 21, 2019 at 8:24 pm

    #3645877

    Unfortunately SSMS does not offer this feature.  It might be worth looking into doing your database development in the full version of Visual Studio.  It does what you are asking for several different file types.

  • May 22, 2019 at 11:13 am

    #3646054

    HI,

    and thanks for the reply.

    I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there?

    Please let me know.

    Thank you

  • May 22, 2019 at 2:08 pm

    #3646150

    itmasterw 60042 wrote:

    HI, and thanks for the reply. I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there? Please let me know. Thank you

    This functionality is not available in VS for .sql files. It is available for other file types, C#, for example.

    If you can use third party tools, take a look at SSMS Boost, which is an SSMS add-on. It facilitates the behaviour you desire, through the use of --region and --endregion comments.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply