Formatting Statements

Aqua Data Studio provides an SQL formatter which may be easily accessed from the Query Analyzer.

With the 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).

Its options include:

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