16.10 - SQL Formatter Preferences - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
This preference page is where you can configure the options which control the Teradata formatting strategy for SQL text using the following options:
Main Option Description
Keyword Case Option Specifies how to format keywords using the following sub-options:
Uppercase Converts all keywords to uppercase
Lowercase Converts all keywords to lowercase
Starts with Uppercase Converts only the first letter to uppercase and the rest of the keyword is lowercase
Unchanged Keywords are left as they were
Identifier Case Option Specifies how to format identifiers using the following sub-options:
Uppercase Converts all identifiers to uppercase
Lowercase Converts all identifiers to lowercase
Starts with Uppercase Converts only the first letter to uppercase and the rest of the identifier is lowercase
Unchanged Identifiers are left as they were
Stacking Lists Option Specifies how to arrange lists, such as Select lists, From lists, Order By lists, Group By lists, Parameter lists, and Column definition lists. If there is only a single item in the list, the formatter always places it on the same line as the context keyword, regardless of the option.
Same Line Places list items all on the same line
Line Break After Comma Places a line break after the comma
Line Break Before Comma Places a line break before the comma
Line Break Before Comma with Space Places a line break before the comma and adds a space after the comma
Unchanged Lists are left as they were
Indentation Option Specifies whether to use spaces or tabs for indentation.
Space Size Specifies the size of the indentation for spaces. The value must be between 0 and 9. If tabs were chosen for the indentation option, the tab size is specified on the General > Editors > Text Editors Preference page (Displayed tab width).
Where Clause Break Option Specifies whether to place the AND and OR elements of the WHERE clause on separate lines or the same line.
  Line Break and Indent Places the list of AND and OR elements on new lines at the indentation level.
  Same Line Places the list of AND and OR elements on the same line.