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

How to prevent formatting certain lines

Is it possible to tell the formatter NOT to format a line (or section) - possibly by using a specific comment?


  • Options
    Hi DennisR,

    Yes that is possible with our new formatting styles.

    You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting styles". When we release the next major version, this will be on by default.
    -- SQL Prompt formatting off
    SELECT 1
    -- SQL Prompt formatting on

    Best wishes,

    Michael Clark
    Technical Lead, SQL Prompt
    Michael Clark
    Technical Lead, SQL Monitor
  • Options
    Thanks. But it would be nice if there was a special comment to turn it off for just one line

    SELECT 1 --xf

    (P.S. I do like the Labs new formatting styles and editor :)
Sign In or Register to comment.