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

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?
Tagged:

Comments

  • 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
    E.g.

    SELECT 1 --xf


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