| Author |
Message |
Hu
Joined: 08 Aug 2019
Posts: 8
Country: China |
|
 Can you customize your own format for SQL code formatting? |
 |
Can you customize your own format for SQL code formatting? JOIN and ON, for example, appear ON the same line
LEFT JOIN ORGANIZE B ON A.deptId = B.ID
|
|
| Thu Aug 08, 2019 10:18 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
You can change that in the options. Please see the Code Formatting tab. Normally the pattern for JOINs is defined in the SELECT rules. But if you have it as a separate rul, then it would override the one inside SELECT
|
|
| Thu Aug 08, 2019 11:27 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Just in case. You may want to define multiple formatting styles using different formatting patterns for different styles. Having the entire join condition always on a single line might be problematic for multi-column joins and make the code difficult to read. The formatting style can be selected dynamically using Ctrl+Shift+F11.
|
|
| Thu Aug 08, 2019 11:31 am |
|
|
Hu
Joined: 08 Aug 2019
Posts: 8
Country: China |
|
| very nice |
|
Ok, thank you very much
|
|
| Thu Aug 08, 2019 11:38 am |
|
|
|
