Is there a way to tell SQL Prompt not to re-format a line of code?

TampaCraig

If I have a line of code that I don't want formatted, is there a way to put a comment at the end of the line to tell SQL formatter not to re-format that line?

Tianjiao_Li

@TampaCraig

This is certainly possible.

1. In a query window, select the code you don't want SQL Prompt to format, and click Ctrl to open the actions list.
2. Type di and select Disable formatting for selected text:
   
   SQL Prompt encloses the selected code within comments:
   

This code now won't be formatted when you run Format SQL.

https://documentation.red-gate.com/sp/sql-code-formatting-and-styles/customizing-your-formatting-style