SQL Formatter Options

Alignment

Alignment is what turns a correctly indented statement into a readable one. SQLinForm can line up commas, aliases, equal signs, arithmetic operators and concatenation operators into vertical columns, so that the eye can scan a long column list or a wide WHERE clause without reading every character.

Alignment

Comma Alignment

ID	Option	What it does	Default
ID066	ProAlign Commas ALI_COMMA	Lines the commas of a column list into one vertical column. Only has a visible effect when several entries share a line, or when leading commas are used.	`on`

Visible whenever several entries share a line, or when leading commas are used.

ID066 off

select emp_nbr, emp_name, dept,
       hire_date, salary, bonus
from   employee

ID066 on

select emp_nbr  , emp_name, dept ,
       hire_date, salary  , bonus
from   employee

Alias Alignment

ID	Option	What it does	Default
ID049	ProAlign ALIAS ALI_AS	Lines up all column aliases at the same position, so the result column names can be read as a list independently of the expressions that produce them. Mutually exclusive with ID073.	`on`

ID049 off

select dept_nbr as nbr,
       employee_name as name,
       salary_amount as sal
from   employee

ID049 on

select dept_nbr      as nbr,
       employee_name as name,
       salary_amount as sal
from   employee

Equal Sign & Operators

ID	Option	What it does	Default
ID073	ProAlign ALIAS at the Position specified in the next Option I... ALI_ASPOSITION	Puts the alias at a fixed column instead of at a position calculated from the longest expression. Fixed positions keep two similar statements comparable side by side; dynamic positions produce more compact output. Mutually exclusive with ID049.	`off`
ID074	ProSpecify Position to align ALIAS ALI_ASPOSITIONVALUE	The fixed column number used when the option above is switched on.	`60`
ID031	ProAlign Equal Signs ( '=', '==', '<', '>', etc ALI_EQUAL	Aligns comparison operators in conditions and assignments, so that the left- and right-hand sides form two readable columns.	`on`
ID032	ProAlign Operators ( '+', '-', '*', ALI_OPERATOR	Aligns arithmetic operators in calculations. Off by default, because it makes sense mainly in expression-heavy statements.	`off`
ID060	ProAlign '\|\|' Concat Operator ALI_CONCAT	Aligns the concatenation operator, which is useful in the long string-building expressions typical of reporting queries.	`on`

ID031 lines up the comparison operators, which splits a condition list into a readable left and right column.

ID031 off

where dept_name = 'Sales'
  and employee_nbr >= 100
  and zip = '64521'

ID031 on

where dept_name    =  'Sales'
  and employee_nbr >= 100
  and zip          =  '64521'

Tip: ID073 with ID074 pins the alias to a fixed column instead of a calculated one. Fixed positions keep two similar statements comparable side by side; calculated positions produce more compact output.

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.