Contents 

Ubitsoft SQL Enlight Online Help

Statements

Data Statement
Schema Statement


Data Statement

Join condition placement
Join condition indention
Join clause alignment
Nested join expression indention
First column in a data statement placement
Column padding in select list
Variable padding in variable declaration
Left operand padding in assignment expression

Data statement layout rules control a set of options that can modify the way data statements are written.

Data Statement Rules

Join condition placement
Specifies if the join condition to be placed on separate line than the join.

Place on new lineJoin condition is placed on a new line.
Place on same lineJoin condition is placed on the same line as the join.

Join condition indention

Indent withDefines the number of spaces that to be used to indent the join condition towards the join keyword when join condition is placed at a new line. This rule depends on the place join condition on new line rule.

Join clause alignment
Specifies the join clause alignment.

Place aligned with statementSpecifies the join clause to be aligned with the statement.
Place aligned with table sources Specifies the join clause to be aligned with the table sources in the join list.

Nested join expression indention
Specifies if to indent joins that are between a join and the join condition.

Indent nested joinsIf checked joins will be indented otherwise nested joins won't be indented.

First column in a data statement placement

Place on a new linePlacement of the first column in a comma list in data statement (SELECT, INSERT, DELETE, UPDATE).

Column padding in select list

Padding width Set the padding width of columns in the select list and change the placement of the column alias.
Rule is ignored if the column length is greater than the selected length or the comma list breaks rule is disabled.

Variable padding in variable declaration

Padding width Set the padding width of variable in the variable declaration statement.

Rule is ignored if the variable length is greater than the selected length or the comma list breaks rule is disabled.

Left operand padding in assignment expression

Padding width Set the padding width of the first operand in an assignment expression in the select list.
Rule is ignored if the first operand length is greater than the selected length or the comma list breaks rule is disabled.

Schema Statement

Definition content indention space
Definition list breaking

Schema statement layout rules control a set of options that can modify the way schema statements are written.

Schema Statement Rules

Definition content indention space
Specifies the indention space of the content of schema statement definition.

Indent withNumber of spaces to indent the content with.

Definition list breaking
Controls if the definition comma list will be broken in multiple lines and where to place the new
line - before or after the comma symbol.

New line beforeEach comma is placed on a new line.
New line after Each comma is placed at the end of the line.