How can I set up a custom formatting style in SQL Prompt

Best Answer

• Options

  Grant Posts: 89 Silver 5

  September 5, 2017 3:33PM edited September 5, 2017 7:15PM Answer ✓

  It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the default style or create a new one. I’d go for creating a new one to start. Then just step through all the different options and save the work when you’re done. As you make changes you can see a sample query or even preview the current query. It makes it really easy to get exactly what you want in terms of style. We even have a nice article telling all about it.
  
  Hope that helps
  

  3 · Share on Twitter