SQL Formatter Preferences - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Go to Window > Preferences > Teradata Datatools > SQL Formatter to access this preference page to configure the options that control the Teradata formatting strategy for SQL text:
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 Indentation Type 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.