You can configure a number of layout rules to specify how the Enlighten SQL command reformats your SQL code.
To do this on the SQL Enlight menu click Options and then select the Layout Rules tab.
The exact effect of customization of each layout rule over the SQL code can immediately be seen in the
Preview Layout box. It shows a SQL statement with all currently active layout rules applied.
- T-SQL statements are completely rewritten thus it follows a couple of rules that cannot be changed.
- FROM WHERE GROUP BY and ORDER BY clauses are always placed on a new line.
- Breaks before the opening and after the closing parenthesis are only inserted when parentheses not take part in expression - neither logical nor arithmetic.
Layout rules are separated into three main groups: General, Expressions and Statements.