SQL Formatting

Hi,

After the following line is entered and Cntr=>F11 is pressed...

select * from TableA a inner join TableB b on a.key = b.key

...it is currently formatted as...

select *

from TableA a inner join TableB b on a.key = b.key

How can it be changed to format it like the following?

select *

from TableA a

inner join TableB b
on a.key = b.key

Which database is that? SQL Assistant version?

By the way, here is the result I get after formatting. I tested it with SQLite connection.

	Code:
	/************************************************************ * Code formatted by SoftTree SQL Assistant © v9.5.453 ***********************************************************/ SELECT FROM TableA a INNER JOIN TableB b ON a.key = b.key

I am using SQL Assist version 9.5.452 with SQL Server Management Studio version 17.4

I get the same format as you after resetting the "Code Formatting" section.

How can it be made to look in my original example?

Do you mean uppercase keywords or something else? I'm not seeing other significant differences.

If uppercasing, there is a separate option for keyword casing.

I'd like the "Inner" statement to be left aligned with the "From" clause. Same for "On".

select *

from TableA a

inner join TableB b
on a.key = b.key

You can modify the "select" rule in the Options on the Code Formatting tab, T-SQL Custom Style. Remove the white space in front of JOIN keyword.

You can use the Test... button in the top-right corner of that tab page to test immediately the results. If satisfied with them, click the Apply button to save your changes.

Just in case, the default hot key for applying custom formatting style to the code is Ctrl+Shift+F11

That worked. Thank you!