Go to
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. |