General

Comma rules
Parenthesis rules
Case
Delimiters
Optionals
Comments
Miscellaneous

Comma rules

Spaces around comma placement
Breaks placement
Comma alignment
Allow breaks if take part in expression
Allow breaks in SELECT list
Allow breaks in GROUP BY list
Allow breaks in ORDER BY list

Comma rules control the way comma separated lists will be formatted.
By default a comma separated list is placed on a single line with no spaces around the comma symbol.

Spaces around comma placement
Specifies the space that to be set in front and/or after the comma symbol

Space before	Sets one space in front the comma
Space after	Sets one space after the comma

Breaks placement
Specifies the position of the comma symbol and if comma list shell be split on multiple lines.

New line before	Each comma is placed on a new line.
New line after	Each comma is placed at the end of the line.
Minimum Items	Specifies the least number of items that the list to contain, in order to be broken into multiple lines.

Comma alignment
Comma alignment rule is only active when the rule for new line in front the comma symbol is active.

Place aligned with statement	The comma is left aligned with the statement start.
Place next to column	The comma is placed close to the column.

Allow breaks if take part in expression
Specifies if the layout rules for breaking comma list in multiple lines to be applied if the comma list takes part in arithmetic or logical expression.

Allow breaks

Select this option to break comma lists that appears in a arithmetic or logical expression.

Allow breaks in SELECT list
Specifies if the layout rules for breaking comma list in multiple lines to be applied on SELECT column list.

Allow breaks

Allow each column in SELECT list to be placed on separate line.

Allow breaks in GROUP BY list
Specifies if the layout rules for breaking comma list in multiple lines to be applied on GROUP BY clause column list.

Allow breaks

Allow each element in GROUP BY list to be placed on separate line.

Allow breaks in ORDER BY list
Specifies if the layout rules for breaking comma list in multiple lines to be applied on ORDER BY clause list.

Allow breaks

Allow each element in ORDER BY list to be placed on separate line.

Parenthesis rules

Breaks around opening parenthesis
Breaks around closing parenthesis
Allow breaks if part of an expression
Space around opening parenthesis
Space around closing parenthesis
Parentheses content indention space

Parenthesis break placement rules, controls the way breaks are placed around parenthesis.

Breaks around opening parenthesis

New line before	Opening parenthesis is placed on a new line Setting is ignored when the parentheses take part in arithmetic expression and the 'Allow breaks if part of an expression' rule is active.
New line after	Content of parentheses is placed on new line.

Breaks around closing parenthesis

New line before	Closing parenthesis is placed on a new line.
New line after	New line is added after the closing parenthesis. Setting is ignored when the parentheses take part in arithmetic expression and the 'Allow breaks if part of an expression' rule is active.

Allow breaks if part of an expression

Allow breaks

Specifies if the layout rules for placing the parenthesis on new line to be applied if the parentheses in arithmetic expression.

Parenthesis space placement rules controls what spaces to be placed around parenthesis.

Space around opening parenthesis

Space before	Places a single space in front of the opening parenthesis. Only applies if there is no new line before the opening parenthesis.
Space after	Places a single space after the opening parenthesis. Only applies if there is no new line after the opening parenthesis.

Space around closing parenthesis

Space before	Places a single space in front the closing parenthesis. Only applies if there is no new line before the parenthesis.
Space after	Places a single space after the closing parenthesis. Only applies if there is no new line after the parenthesis.

Parentheses content indention space
Controls the indention of the content of the parentheses.

Indent with

Specifies the number of spaces that to be used for indention of the parentheses content.

Case

Change keywords case
Change identifiers case
Change variables case
Change predefined objects case

Token case layout rules control the casing of the keywords, identifiers, variables and predefined tokens.
Using these rules you can specify how each of these toke n types will be written.

Change keywords case

UPPER	If set, all keywords are written in uppercase.
Capitalize	Capitalizes all keywords.
lower	If set, all keywords are written in lowercase.

Change identifiers case

UPPER	If set, all identifiers are written in uppercase.
Capitalize	Capitalizes all identifiers.
Lower	If set, all identifiers are written in lowercase.

Change variables case

UPPER	If set, all variables are written in uppercase.
Capitalize	Capitalizes all variables.
lower	If set, all variables are written in lowercase.
Same as declaration	If set, all variable instances will inherit the case of the variable from it's declaration.

Change predefined objects case

UPPER	If set, all predefined objects are written in uppercase.
Capitalize	Capitalizes all predefined objects.
lower	If set, all predefined objects are written in lowercase.

Delimiters

Quoted identifiers
Quoted strings

Delimiters layout rules can modify the way of the identifiers and strings delimited with double quotation marks are rewritten.
The rules behavior depends on the state of the QUOTED_IDENTIFIERS option.

Quoted identifiers

Delimit quoted	If set, all quoted identifiers are delimited.
Leave with no change	Quoted identifiers are not changed.

Quoted strings

Make double quotation marks delimited strings - single quoted	If set, all double quotation marks delimited strings are rewritten as single quoted strings.
Leave with no change	Double quotation marks delimited strings are not changed.

Optionals

• Change the optional AS keyword usage
• Change the optional INTO keyword usage
• Change the optional FROM keyword usage
• Change statement terminator semicolon usage

Optional layout rules control if a set of optional tokens to be enforced or skipped.

Change the optional AS keyword usage

Always use	Enforce usage of the AS keyword when specifying aliases, column definitions and etc.
Never use	Do not output AS keyword in alias, column definitions and etc.

Change the optional INTO keyword usage

Always use	INTO keyword will always be used in INSERT statements.
Never use	INTO keyword will be skipped in INSET statement.

Change the optional FROM keyword usage

Always use	Optional FROM keyword is always used in DELETE statement.
Never use	Skip Optional FROM keyword in DELETE statement.

Change statement terminator semicolon usage

Always use	Statement terminator semicolon will be placed after each statement.
Never use	No statement terminator semicolons will appear after statements.

Comments

Comments presence
Last comment in statement placement
Multiline block comment placement
Block comment starting with '/**' placement
Line comment starting with '---' placement

Comment layout rules control the line and block comments are placement.

Comments presence

Strip comments

Specifies if comments to be removed from the script.

Last comment in statement placement

Place on new line

The rule controls if the last comment in a statement to be placed on a new line.

Multiline block comment placement

Place on new line

The rule controls if multiline block comments to be placed on new line.

Block comment starting with '/**' placement

Place on new line

The rule controls if block comments starting with '/**' to be placed on new line.

Line comment starting with '---' placement

Place on new line

The rule controls if block comments starting with '---' to be placed on new line.

Miscellaneous

Tabify or untabify white space
Keywords padding

Miscellaneous set of  layout rules.

Tabify or untabify white space

Tabify white space	Specify to output tab-length white spaces as tabs. The tab size that is used for the conversion is the text editor's tab size.
Replace tabs with spaces	Specify tabs as white spaces. The tab size that is used for the conversion is the text editor's tab size.

Keywords padding

Padding

Specify padding for the keywords in the SELECT,UPDATE, INSERT and DELETE statements.

---