16.20 - About Notation Conventions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2020-03-25
dita:mapPath
xzf1512079057909.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
kby1472250656485

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.