SQL Formatter Options

Comments

SQLinForm never changes the text of a comment, but it can decide where a comment sits: on its own line or trailing, aligned into a column, converted between line and block style, or removed entirely. Useful when you inherit a script whose comments have drifted out of place over the years.

Comments

Line Comments

ID	Option	What it does	Default
ID076	ProAdd Linebreak Before Line Comments LBB_LINECOMMENT	Puts a line comment on its own line instead of leaving it at the end of the preceding statement line.	`off`

ID076 off

select dept_nbr, -- department key
       dept_name
from   dept

ID076 on

select dept_nbr,
       -- department key
       dept_name
from   dept

Block Comments

ID	Option	What it does	Default
ID077	ProAdd Linebreak Before/After Block Comments LBB_BLOCKCOMMENT	Isolates a block comment with a linebreak before and after, so it reads as a heading between two statements.	`on`
ID050	ProAlign Line Comments ALI_COMMENT	Aligns trailing line comments into one column, which turns a series of commented columns into a readable two-column layout.	`on`
ID115	ProAlign Block Comments ( /* and */ ) ALI_LEFTPARACOMMENT	Aligns the opening and closing markers of block comments with each other.	`on`
ID116	ProLeft-Align Block Comment Lines IND_PARACOMMENT	Aligns the individual lines within a multi-line block comment on the left, removing indentation inherited from wherever the comment was originally written.	`on`
ID057	ProConvert Line Comments into Block Comments EDIT_REPL_COMMENT	Rewrites `--` comments as `/* */` comments. Handy when a target system or deployment tool strips line comments.	`off`
ID154	ProConvert Block Comments into Line Comments EDIT_REPL_PARACOMMENT	The reverse: rewrites block comments as line comments. Note that a block comment spanning several lines becomes several line comments.	`off`

ID050 pulls trailing line comments into one column.

ID050 off

select dept_nbr, -- key
       employee_name, -- full name
       salary -- gross amount
from   employee

ID050 on

select dept_nbr,      -- key
       employee_name, -- full name
       salary         -- gross amount
from   employee

Delete Comments

ID	Option	What it does	Default
ID035	ProDelete Comments EDIT_DEL_COMMENT	Removes all comments from the output. Irreversible – keep the original file.	`off`

ID035 off

-- monthly headcount report
select dept_nbr,   -- key
       count(*)    /* headcount */
from   employee

ID035 on

select dept_nbr,
       count(*)
from   employee

Tip: Deleting comments cannot be undone by re-formatting – the text is gone from the output. Keep the original file.

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.