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