How to Read Syntax | Teradata Vantage - How to Read Syntax - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

This document uses the following syntax conventions.

Syntax Convention Meaning
KEYWORD
Keyword. Spell exactly as shown.

Many environments are case-insensitive. Syntax shows keywords in uppercase unless operating system restrictions require them to be lowercase or mixed-case.

variable
Variable. Replace with actual value.
number
String of one or more digits. Do not use commas in numbers with more than three digits.

Example: 10045

[ x ]
x is optional.
[ x | y ]
You can specify x, y, or nothing.
{ x | y }
You must specify either x or y.
x [...]
You can repeat x, separating occurrences with spaces.

Example: x x x

See note after table.

x [,...]
You can repeat x, separating occurrences with commas.

Example: x, x, x

See note after table.

x [delimiter...]
You can repeat x, separating occurrences with specified delimiter.
Examples:
  • If delimiter is semicolon:

    x; x; x

  • If delimiter is {,|OR}, you can do either of the following:
    • x, x, x
    • x OR x OR x

See note after table.

( [ x [ [,] y ] ] )
Depends on context. See descriptions of syntax elements that use parentheses.
You can repeat only the immediately preceding item. For example, if the syntax is:
KEYWORD x [...]

You can repeat x. Do not repeat KEYWORD.

If there is no white space between x and the delimiter, the repeatable item is x and the delimiter. For example, if the syntax is:

[ x, [...] ] y
  • You can omit x: y
  • You can specify x once: x, y
  • You can repeat x and the delimiter: x, x, x, y