SQL Formatter Options

White Spaces

Fine-grained control over the spaces around punctuation – commas, brackets and operators – plus how blank lines from the original script are treated and whether the whole statement is shifted to the right. These are the smallest adjustments SQLinForm offers, and often the ones that make a house style feel finished.

White Spaces

White Spaces Options

ID	Option	What it does	Default
ID040	ProWhite Spaces Around Commas WHSP_COMMA	Spacing around commas. `NONE` leaves whatever spacing the source already has – it does not mean 'no spaces'. `NOAROUND` removes the spaces, `ONEBEFORE` / `ONEAFTER` / `ONEAROUND` enforce one space before, after, or on both sides. Choices: `NONE` No Change · `NOAROUND` No White Spaces Around Comma · `ONEBEFORE` One Space Before Comma · `ONEAFTER` One Space After Comma · `ONEAROUND` One Space Before and After Comma	`NONE`
ID036	ProWhite Spaces Around Brackets WHSP_BRACKET	Spacing around brackets. `NONE` leaves the source spacing untouched, `NOAROUND` removes it, `ONEINSIDE` puts one space just inside the brackets, `ONEOUTSIDE` just outside, `ONEAROUND` on both sides. Choices: `NONE` No Change · `NOAROUND` No White Spaces Around Brackets · `ONEINSIDE` One Space Inside Brackets · `ONEOUTSIDE` One Space Outside Brackets · `ONEAROUND` One Space Inside and Outside Brackets	`NONE`
ID045	ProWhite Spaces Around Operators WHSP_EQUAL	Spacing around comparison and arithmetic operators. `NONE` keeps the source spacing unchanged, `NOAROUND` removes it, and `ONEAROUND` enforces one space on each side, turning `a=1` into `a = 1`. Choices: `NONE` No Change · `NOAROUND` No White Spaces Around Operators · `ONEAROUND` One Space Before and After Operators	`NONE`
ID072	ProKeep Blank Lines EDIT_DELETE_EMPTYLINES	How many blank lines from the source survive: `NONE` keeps none, `ONE` collapses each run to a single blank line, `ALL` keeps them all. Choices: `NONE` Remove All Blank Lines · `ONE` Keep One Blank Line · `ALL` Keep All Blank Lines	`NONE`
ID084	ProKeep Indention from 1st Line IND_AUTO_1STLINE	Adds the indentation the first line already had to every line of the output. Useful for SQL embedded in indented application code. The amount is added on top of ID070.	`off`

ID045 controls the spacing around comparison and arithmetic operators.

ID045 = NONE (leave as is)

where a=1
  and b<>2
  and c>=3

ID045 = ONEAROUND

where a = 1
  and b <> 2
  and c >= 3

Tip: ID084 keeps the indentation the first line already had and applies it to the whole statement – useful for SQL that sits inside indented application code.

Shift Complete SQL Statement by Spaces

ID	Option	What it does	Default
ID070	ProShift SQL by this Amount of Spaces IND_INITIALVALUE	Shifts the complete formatted statement to the right by this number of spaces, on top of any indentation the formatter itself produces. ID084, if on, adds to this value.	`0`

ID070 = 0

select dept_nbr
from   dept

ID070 = 4

    select dept_nbr
    from   dept

Option IDs are identical across all SQLinForm editions (VS Code, JetBrains, SSMS, Notepad++, Online Formatter) and are the keys stored inside a profile file. Generated from properties.json 2026.8.21.0.