Query Window -
SQL Formatter
Aqua Data Studio provides an SQL formatter which
may be easily accessed from the Query Analyzer.
With a single key stroke (CTRL-B) the user may format an SQL
statement according to a set of options. By default, the editor
will prompt the user with a dialog of options for formatting.
Application level settings for the formatter are located in File->Options->Formatter.
In the options seciton a user may specify for the formatter to
format SQL without prompting the user. The user may also format all
SQL statements in a script with one key stroke (CTRL-Shift-B).
Options:
Line Break
- Before Comma - Adds a line break before the comma
- After Comma - Adds a line break after the comma
- Before Logical Operators - Adds a line break before
logical operators (e.g. AND, OR)
- After Logical Operators - Adds a line break before
logical operators (e.g. AND, OR)
- After SQL Keywords - Adds a line break after SQL
keywords (e.g. SELECT, FROM, WHERE)
- Break for CASE Keywords - Adds line breaks for CASE
keywords (i.e. CASE, WHEN, THEN, ELSE, END)
- Break for Brackets - Adds line breaks for brackets in
AND, OR and WHEN
- Wrap Line - Wraps line automatically
- Line Wrap Column - The maximum column before line
wraps
Uppercase
- SQL Keywords - Turns SQL keywords uppercase
- Full SQL - Turns the full SQL statement uppercase
Indentation
- Number of spaces per Tab - Number of spaces to expand
in a TAB if Tabs are used for indentation
- Use Tabs for Indentation - Determines whether a real
TAB is used or whether a TAB is expanded to spaces
- Alignment on Operators - Alignment on =, , > and
AS
- Alignment on JOIN - Alignment on table joins
|
|
