Use the Indentation section of the formatting options to setup indentation rules for automatic code formatting. You can apply the following options:
SQL Statements
Indent clauses
Applies indentation to SQL clauses.
Clause content indentation
Determines how clause content will be indented.
Do not indent clause content
Line up clause content with a clause start.
Indent clause content normally
Add indentation relative to a clause start.
Indent clause content dynamically
Line up clause content by a last character of a clause keyword.
Align clause content at offset
Line up clause content by the specified offset. Click the 
ellipsis button and enter the offset value.
Align "JOIN" clauses as table
Select it to align "JOIN" clauses as table.
Indent "JOIN" clauses in "JOIN" chains
Select it to place "JOIN" clauses in "JOIN" chains on a new line.
Align "CASE" operation by logical operator
Select it to align "CASE" operation by logical operator.
Indent "CASE" operation content
Select it to indent "CASE" operation content.
Code
Indent block contents
Select to indent blocks of the stored code.
Indent "BEGIN" and "END"
Select to indent "BEGIN" and "END".
Indent flow control statement content
Select to indent flow control statements
Label indentation
Place label in leftmost column
Select to place label in leftmost column.
Place label one indent less than current
Select to place a label one indent less than current.
Indent labels normally
If selected, a label will be at the current indentation level.
Variables declaration
Indent variable types compactly
Keyword DECLARE, variable name, and variable type will be separated with one space.
Indent variable types dynamically
Several variable declarations will be lined up in columns.
Align variable types at offset
Keyword DECLARE, variable name, and variable type will be separated with the entered number of spaces.
Parameters declaration
Indent parameters modes and types compactly
Separates parameter name, mode, and type with one space.
Indent parameters modes and types types dynamically
Several parameter specifications will be lined up in columns.
Align parameters modes and types at offset
Separates parameter name, mode, and type with entered number of spaces.
Align parameters to the opening parenthesis
Select to align parameters to the opening parenthesis.
Reset Page Defaults
Click this button to reset settings on this page to the default ones.
See Also