Allow the 'on' clause to be aligned with the JOIN clause
"Support" was of no assistance, but I'd like to have my 'On' clause aligned with the join clause, but it's not possible:
from
[ExtendedEvents].[Events] ee -- on new line
join
OtherTable
on -- inline with JOIN
OtherTable.[ID] = ee.[ID]
where
Peter Dudley
shared this idea
AdminDevart
(_, Devart)
responded
This can be setup as follows:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile and click the ‘Open Selected…’ button.
4. Navigate to the ‘SELECT → FROM → JOIN’s’ section.
5. Unselect the ‘Indent ON keyword by 4 columns’ option.
-
Peter Dudley
commented
If I could work out how to add code, I'd show you that this doesn't work, unless there is some other option I need to set somewhere. The 'on' keyword aligns with the tablename, selecting indent then moves it 4 to the right, unselecting then aligns it with the tablename.
I feel that it can/should be possible, but having purchased I'm now finding the real limitations.