Use the New Lines section of the formatting options to setup options for placing clauses on new lines when using automatic code formatting. You can apply the following options:
Place open brace on new line for DDL statements
Select to place open brace on a new line for DDL statements. Selected by default.
Place closing brace on new line for DDL statements
Select to place closing brace on a new line for DDL statements. Selected by default.
Place subquery in braces on new line
Select to place subquery in braces on a new line.
Place subquery closing brace on new line
Select to place subquery closing brace on a new line.
Place clause content on new line
Select it to place the clause content on a new line.
Set new lines for "CASE" operation
Place "CASE" operation on new line
Select it to place "CASE" operation on a new line.
Place "WHEN" in "CASE" operation on new line
Select it to place "WHEN" in "CASE" operation on a new line.
Place "THEN" in "CASE" operation on new line
Select it to place "THEN" in "CASE" operation on a new line.
Place "ELSE" in "CASE" operation on new line
Select it to place "ELSE" in "CASE" operation on a new line.
Place "CASE" operation branches content on new line
Select it to place "CASE" operation branches content on a new line.
Set new lines for "SELECT" clauses
Place first column in select list on new line
Select it to place first column in select list on a new line.
Place "FROM" on new line
Select it to place "FROM" clause on a new line.
Place "WHERE" on new line
Select it to place "WHERE" clause on a new line.
Insert new line after "AND", "OR" operators in logical expressions in "WHERE" and "HAVING"
Select it to insert new line after "AND", "OR" operators in logical expressions in "WHERE" and "HAVING".
Place "AND", "OR" operators in logical expressions in "WHERE" and "HAVING" on new line
Select it to place "AND", "OR" operators in logical expressions in "WHERE" and "HAVING" on a new line.
Place "INTO" on new line
Select it to place "INTO" clause on a new line.
Place "JOIN" clauses on new line
Select to place "JOIN" clauses on a new line.
Place "ON" condition in JOIN clause on new line
Select it to place "ON" condition in JOIN clause on a new line.
Place "GROUP BY" on new line
Select to place "GROUP BY" clause on new a line.
Place "HAVING" on new line
Select it to place "HAVING" clause on a new line.
Place "COMPUTE" on new line
Select it to place "COMPUTE" clause on a new line.
Place "FOR" on new line
Select it to place "FOR" clause on a new line.
Place "OPTION" on new line
Select it to place "OPTION" clause on a new line.
Place "ORDER BY" on new line
Select it to place "ORDER BY" clause on a new line.
Place "SELECT" in "UNION" statement on new line
Select it to place "SELECT" in "UNION" statement on a new line
Set new lines for "INSERT" clause
Place "INTO" on new line
Select it to place "INTO" clause on a new line.
Place "VALUES" on new line
Select it to place "VALUES" clause on a new line.
Place "SELECT" on new line
Select it to place "SELECT" clause on a new line.
Place "OUTPUT" on new line
Select it to place "OUTPUT" clause on a new line.
Set new lines for "UPDATE" and "DELETE" clauses
Place "SET" on new line
Select it to place "SET" clause on a new line.
Place "FROM" on new line
Select it to place "FROM" clause on a new line.
Place "WHERE" on new line
Select it to place "WHERE" clause on a new line.
Insert new line after "AND", "OR" operators in logical expressions in "WHERE"
Select it to insert new line after "AND", "OR" operators in logical expressions in "WHERE".
Place "AND", "OR" operators in logical expressions in "WHERE"
Select it to place "AND", "OR" operators in logical expressions in "WHERE".
Place "OUTPUT" on new line
Select it to place "OUTPUT" clause on a new line.
Place "OPTION" on new line
Select it to place "OPTION" clause on a new line.
Set new lines for code
Place parameters declaration on new line
Select it to place parameter declaration on a new line.
Place closing brace on new line for multi-line parameter list
Select it to place a closing brace on a new line for a multi-line parameter list.
Place "BEGIN" on separate line
Select it to place "BEGIN" on a separate line.
Place goto label on separate line
Select it to place a goto label on a separate line.
Add empty lines
Around "IF" statements
Select to add an empty line around "IF", "CASE" statement.
Around "WHILE" statements
Select to add an empty line around "LOOP", "REPEAT", and "WHILE" statements.
Before goto label
Select to add an empty line before goto label.
Around DDL statements
Select to add an empty line around DDL statements.
Reset Page Defaults
Click this button to reset settings on this page to the default ones.
See Also