SQL Server 2008 / 2012 - views & sql formatting

Question

Hopefully this is a newbie question.

So if I have kind of a long set of selects in my SQL and a couple of sub-selects within my where clause, I'm less than satisfied with the formatting in the view designer, which appears to be the only way to display/show my views after they are saved.

So, in short, is there any way to directly edit my views within SSMS, and have the views retain the formatting in my code?

i.e.;

select case /*comment */
  when a = 5  
   then b = 2 
   else b = 4  /* why b 4 */
  end as field_1,
  dt as field_2,...

get's all mashed up

select case /*comment */     when a = 5                  
then b = 2                 else b = 4  /* why b 4 */              
end as field_1,             
dt as field_2,...

Or something along those lines.

Righ click -> script view as -> alter to -> new query window. — Zohar Peled, Aug 16 '15 at 17:41
https://sqlblog.org/blogs/aaron_bertrand/archive/2009/10/14/bad-habits-to-kick-using-the-visual-designers.aspx — Aaron Bertrand, Aug 17 '15 at 01:08

score 3 · Accepted Answer · answered Aug 16 '15 at 17:41

Are you using the query designer? Instead, use an SSMS query window. From the SSMS Object Explorer, right-click on the view and select Script View as-->Alter To-->New Query Editor window. Format the view source in the query window and run the script to change the view. Your formatting will be preserved.

SQL Server 2008 / 2012 - views & sql formatting

1 Answers1