SQL Formatter Options

SQL Linebreaks

Two settings that act on the statement as a whole: a length threshold below which a short statement is left on one line, and how the statement delimiter is placed. They are deliberately separate from the per-keyword linebreak options, because they override them.

SQL

Small SQL Linebreaks

ID	Option	What it does	Default
ID027	ProNo Linebreak for SQL Statements smaller than this number o... LB_WIDTH_SMALL_SQL	Statements shorter than this many characters are left on a single line. This overrides all linebreak options and keeps trivial statements such as `select count(*) from dept` from being spread over four lines.	`10`

A statement below the threshold is left on one line, whatever the linebreak options say.

ID027 = 0

select
    count(*)
from
    dept

ID027 = 40

select count(*) from dept

Linebreak Delimiter

ID	Option	What it does	Default
ID152	FreeLinebreak Before Statement Delimiter LBB_SEMIKOLON	Puts the statement delimiter on its own line rather than directly after the last token.	`off`
ID155	ProDouble Linebreak After Delimiter LBA_SEMIKOLON_DOUBLE	Inserts a blank line after each delimiter, which separates the statements of a long script visually.	`off`

ID152 off, ID155 off

select dept_nbr from dept;
select emp_nbr from employee;

ID152 on, ID155 on

select dept_nbr from dept
;

select emp_nbr from employee
;

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.