What are the challenges you face when working across database platforms? Take the survey

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

Hi community, can anyone help me with this?

Best Answer

  • Options
    GrantGrant Posts: 89 Silver 5
    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
Sign In or Register to comment.