I would like the ability to get Format SQL to handle my JOIN formatting - I like to have my JOINs look like this:
sys.indexes i ON t.OBJECTID = i.objectid
That is: I want to have my tables being joined lined up with the (intended) table in the FROM clause, and I like to have my JOIN condition on the same line as the joined table.
Right now, I cannot seem to get this to work - the table name and join condition are always stuck onto the same line as the INNER JOIN clause.... any hope that'll be added some day?
This feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
The Prompt Team
The new formatting features are great. The only thing I see missing is the ability to put the join on the same line as the table, but after the table.