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

TampaCraig · May 15, 2020 3:42PM

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 · May 18, 2020 7:58AM

@TampaCraig

This is certainly possible.

In a query window, select the code you don't want SQL Prompt to format, and click Ctrl to open the actions list.
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

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk