How can we help you today? How can we help you today?

Auto Formatting question - Right align JOIN to FROM

Hi, I am wondering if there is a way to right align the JOIN keyword to FROM in the auto formatter, so the formatting looks like the below?


When I set the Option 'JOIN keyword alignment' to 'Right aligned to FROM' I get the following instead:

Which is right aligning INNER but not JOIN.

Is there a way to right align JOIN to FROM?
Adam12312312
0

Comments

4 comments

Sort by
  • cperez
    Good Afternoon,

    In order to better assist you, could you confirm which version of SQL Prompt you are utilizing?
    cperez
    0
  • Adam12312312
    Hi, I am on version 10.14.10.7538
    Adam12312312
    0
  • cperez
    Thanks for the update Adam,

    I was able to test this locally and at this time, it does not appear you can right align on the INNER or LEFT portion of the JOIN clause using a custom formatting style. Fortunately, I was able to find a vote for this issue currently being held on our SQL Prompt feature suggestion page which I will link below.

    https://redgate.uservoice.com/forums/94413-sql-prompt/filters/new?query=Right align on INNER JOIN

    I encourage you to vote on this issue so it can possibly be introduced in a future version.

    Cheers,

    Christian Perez
    cperez
    0
  • Adam12312312
    Thank you Christian!
    Adam12312312
    0

Add comment

Please sign in to leave a comment.