Collapse/Expand Code Blocks

Question

In Microsoft SQL Server Management Studio 2016, how do i generate the "-" and "+" (like image below) to collapse/expand code blocks?

Refer to https://learn.microsoft.com/en-us/sql/ssms/scripting/code-outlining?view=sql-server-ver16 — Tokci, Dec 21 '22 at 16:55

score 4 · Accepted Answer · answered Mar 03 '18 at 20:37

4

Use Begin End for the block of code

answered Mar 03 '18 at 20:37

Vishal Malhotra

56
2

https://learn.microsoft.com/en-us/sql/ssms/scripting/code-outlining?view=sql-server-ver16 – Tokci Dec 21 '22 at 16:54

score 0 · Answer 2 · answered Mar 07 '17 at 18:57

I can't find any way to control it. Based on the lag time between opening a file and seeing the code folding/blocks appear, I think it's based on parsing the code and then creating foldable blocks based upon that analysis and SSMS knowing the syntax of SQL statements/queries.

Collapse/Expand Code Blocks

2 Answers2