SQL Formatter Options

INSERT, UPDATE, DELETE

Formatting for the three DML statements. The INSERT options mostly concern the two bracketed lists – columns and values – which are easiest to compare when they are stacked with one entry per line. The UPDATE and DELETE options control the SET clause and the comma placement inside it.

INSERT

An INSERT holds two parallel bracketed lists. They are easiest to verify when both use the same layout, so that the n-th column and the n-th value sit on the same line number.

INSERT Brackets

ID	Option	What it does	Default
ID108	ProLinebreak Before '(' LBB_OPENINSERTBRACKET	Puts the opening bracket of the column list on a new line.	`on`
ID109	ProLinebreak After '(' LBA_OPENINSERTBRACKET	Starts the first column on the line after the opening bracket.	`on`
ID110	ProLinebreak Before ')' LBB_CLOSEINSERTBRACKET	Puts the closing bracket on a new line, where it terminates the list.	`on`
ID111	ProLinebreak After ')' LBA_CLOSEINSERTBRACKET	Starts whatever follows – usually `VALUES` or a SELECT – on the line after the closing bracket.	`on`

All four off

insert into employee (emp_nbr, emp_name, dept_nbr) values (1, 'Smith', 10)

All four on

insert into employee
(
    emp_nbr,
    emp_name,
    dept_nbr
)
values
(
    1,
    'Smith',
    10
)

Columns and Values

ID	Option	What it does	Default
ID112	ProIndent Columns and Values IND_INSERTBRACKET	Indents the column and value lists one level deeper than the INSERT keyword.	`on`
ID149	ProNumber of Columns or Values per Line LB_NBR_COMMASINSERTPERLINE	How many columns or values share one line. `1` makes the n-th column and the n-th value line up on the same line number, which is the fastest way to check a wide INSERT. Choices: `1`, `2`, `3`, `4`	`1`

With one entry per line the n-th column and the n-th value share a line number, which is the fastest way to verify a wide INSERT.

ID149 = 4

(
    emp_nbr, emp_name, dept_nbr, hire_date
)
values
(
    1, 'Smith', 10, '2026-01-15'
)

ID149 = 1

(
    emp_nbr,
    emp_name,
    dept_nbr,
    hire_date
)
values
(
    1,
    'Smith',
    10,
    '2026-01-15'
)

Commas

ID	Option	What it does	Default
ID207	ProLinebreak Before Comma LBB_COMMAINSERT	Puts the comma at the start of the next line rather than at the end of the current one.	`off`
ID208	ProLinebreak After Comma LBA_COMMAINSERT	Starts the next entry on the line after the comma – the conventional trailing-comma style.	`on`

ID208 on (trailing comma)

(
    emp_nbr,
    emp_name,
    dept_nbr
)

ID207 on (leading comma)

(
    emp_nbr
  , emp_name
  , dept_nbr
)

UPDATE, DELETE

UPDATE

ID	Option	What it does	Default
ID150	FreeLinebreak After UPDATE LBA_UPDATE	Starts the table name on the line after UPDATE.	`on`
ID209	ProLinebreak Before Comma LBB_COMMAUPDATE	Leading commas in the SET clause: the comma opens the line of the assignment that follows it.	`off`
ID210	ProLinebreak After Comma LBA_COMMAUPDATE	Trailing commas in the SET clause: each assignment ends with its comma and the next starts on a new line.	`on`
ID211	ProLinebreak Before SET LBB_SET_UPDATE	Puts SET on a new line, separating it from the table name.	`on`
ID212	ProLinebreak After SET LBA_SET_UPDATE	Starts the first assignment on the line after SET, so that all assignments form one block.	`on`

ID150 off, ID211 off, ID212 off

update employee set salary = salary * 1.05, bonus = 500 where dept_nbr = 10

ID150 on, ID211 on, ID212 on

update
    employee
set
    salary = salary * 1.05,
    bonus  = 500
where dept_nbr = 10

DELETE

ID	Option	What it does	Default
ID151	FreeLinebreak After DELETE LBA_DELETE	Starts the FROM clause on the line after DELETE.	`on`

ID151 off

delete from employee where dept_nbr = 10

ID151 on

delete
from   employee
where  dept_nbr = 10

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.