Syntax Diagram Conventions - Teradata Database

SQL Data Manipulation Language
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database
 

Item

Definition / Comments

Letter

An uppercase or lowercase alphabetic character ranging from A through Z.

Number

A digit ranging from 0 through 9.

Do not use commas when typing a number with more than 3 digits.

Word

Keywords and variables.

  • UPPERCASE LETTERS represent a keyword.

    • Syntax diagrams show all keywords for SQL statements in uppercase, unless operating system restrictions require them to be in lowercase.

  • lowercase letters represent a keyword that you must type in lowercase, such as a Linux command.
  • Mixed Case letters can be used to represent functions, methods, and other non-SQL keywords that can be entered in uppercase, lowercase or mixed case.
  • lowercase italic letters represent a variable such as a column or table name.

    • Substitute the variable with a proper value.

  • lowercase bold letters represent an excerpt from the diagram. The excerpt is defined immediately following the diagram that contains it.
  • UNDERLINED LETTERS represent the default value. This applies to both uppercase and lowercase words.

    • Spaces

    Use one space between items such as keywords or variables.

    Punctuation

    Type all punctuation exactly as it appears in the diagram.

    The main path along the syntax diagram begins at the left with a keyword, and proceeds, left to right, to the vertical bar, which marks the end of the diagram. Paths that do not have an arrow or a vertical bar only show portions of the syntax.

    The only part of a path that reads from right to left is a loop.