16.20 - About Notation Conventions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

This section describes the notation conventions used in this document.

Convention Description
Syntax Diagrams

Describes SQL syntax form, including options.

Square braces in the text

Represent options. The indicated parentheses are required when you specify options.

For example:

DECIMAL [(n[,m])] means the decimal data type can be defined

optionally:
  • without specifying the precision value n or scale value m
  • specifying precision (n) only
  • specifying both values (n,m)
You cannot specify scale without first defining precision.
  • CHARACTER [(n)] means that use of (n) is optional.

The values for n and m are integers in all cases.