Competition: What’s your favorite Redgate tool? Enter now.

Formatting - new line & indent after clauses (eg. WHERE)

blazdaxblazdax SloveniaPosts: 17 Bronze 2
edited October 4, 2016 6:33AM in SQL Prompt
I'd like to see options about new line and indenting for all major clauses. Similar to what you did with JOIN in 7.3.0.587.

Example:
SELECT
...text
FROM
...text
WHERE
...text
GROUP BY
...text
HAVING
...text
ORDER BY
...text

Comments

  • Hi B.Dax,

    This should already be possible in the current beta version (the change in 7.3.0.587 was actually to bring FROM/JOINS inline with everything else).

    If you make a copy of the default style and then set "Place first item on new line" on the lists page to "Always" it should give you a style that looks like your example:
    k5LWz7D.png

    Let me know if that helps.

    Thanks,
    Aaron.
  • blazdaxblazdax SloveniaPosts: 17 Bronze 2
    Hi Aaron,

    Seems that's it.
    Apparently I missed that option, thanks :)
Sign In or Register to comment.