Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

UNION ALL and "Right aligned to statement" option

PioLPioL Posts: 4 New member
When editing formatting style, in Statements => Data (DML) => Clauses section there is an option called "Clause alignment" which I set to "Right aligned to statement".

It works fine except when a statement has the UNION ALL opreator in which case the UNION ALL is shifted one character to the left causing the visual flow of the query to break slightly:



Is there any way to get this UNION ALL statement shifted right by 1 character by the auto-formatter?
Tagged:

Answers

  • Hi PioL,

    Thanks for posting on the Redgate forums. I have asked the team to investigate this and will provide an update as soon as possible.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Hi PioL,

    This has been raised as a bug with internal reference  SP-7603. I will provide a further update on this when I get it.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.