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