SQL Formatter Options
General Options
The General Options apply to every statement SQLinForm formats, regardless of the SQL command. Start here: pick your database dialect, decide how deep one indentation level is, and tell the formatter which characters mark strings and statement boundaries in your code. Everything on the other option pages builds on these settings.
General Options
| ID | Option | What it does | Default |
|---|---|---|---|
| ID033 | FreeYour Database SRCE_DB | Sets the SQL dialect. The parser then recognises the keywords, data types, functions and proprietary syntax of that database – for example CONNECT BY in Oracle or QUALIFY in Snowflake. Choose ANSI SQL if your scripts must work across several systems.Choices: ANSI SQL, Athena, Aurora, Azure, BigQuery, ClickHouse, Databricks SQL, DB2 zOS/UDB, DuckDB, Greenplum ... (28 in total) | ANSI SQL |
| ID002 | FreeGeneral Number of Spaces for Indention GEN_NBR_SPACES_INDENT | Defines how many spaces make up one indentation level. Every Indent option on the other pages is a multiple of this value, so changing it here rescales the whole document. Choices: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 ... (21 in total) | 4 |
| ID071 | FreeUse the Backslash Character as Escape Character SRCE_USE_ESCAPECHARACTER | Treats a backslash inside a string literal as an escape character, as MySQL does by default. Leave this off for databases where a backslash is an ordinary character, otherwise string literals containing Windows paths will be misread. | off |
| ID018 | FreeDecimal Point is Comma GEN_DECIMALPOINT_IS_COMMA | Tells the parser that a comma between two digits is a decimal separator, not a list separator. Without it, a literal such as 1,50 would be split across two lines. | on |
| ID160 | FreeStatement Delimiter Character DELIMITER1 | The character that terminates a statement. SQLinForm uses it to tell one statement from the next when formatting a whole script. | ; |
| ID007 | FreeQuote Character SRCE_QUOTECHAR | The character that encloses string literals. Everything between two of these characters is passed through unchanged – no casing, no linebreaks, no alignment. | ' |
ID002 sets the width of one indentation level. Every "Indent" option elsewhere is a multiple of it.
ID002 = 2
select dept_nbr, dept_name from dept
ID002 = 4
select dept_nbr, dept_name from dept
Tip: ID033 should match the database you actually run against. It decides which keywords and functions the parser recognises – with the wrong dialect, proprietary syntax is treated as plain identifiers and stays unformatted.
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.